最新的修改方案,提示 specified key was too long,怎么解决?
遇到的问题如下:
Syntax error or access violation: 1071 Specified key was t
oo long; max key length is 1000 bytes (SQL: alter table users
add uniqueusers_email_unique
(email
))
完美解决方案:
将文件
F:\wamp64\www\Laravel\vendor\laravel\framework\src\Illuminate\Database\Schema\Builder.php
里面的
public static $defaultStringLength = 255; 改为
public static $defaultStringLength = 191;
改完后再执行
推荐文章: