SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length

SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length

方法一:保证mysql是5.7就行了,因为我用的是mamp环境,我的mysql版本是5.6.3

SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length

方法二 :是因为laravel使用了新的字符集设置,修改一下即可

 

 

SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length

 

 

SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length

 

SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length

SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length

 

删除表

然后再执行 php artisan migrate即可

 

SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length