首页 > 数据库 >SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length i

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

时间:2023-01-01 13:12:38浏览次数:53  
标签:violation max long 1071 access key 42000

Laravel5.4默认使用utf8mb4字符编码,而不是之前的utf8编码。因此运行php artisan migrate 会出现如下错误:

Illuminate\Database\QueryException
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes

原因:mysql版本较低

解决办法:

app\Providers\AppServiceProvider.phpboot()方法添加:

Schema::defaultStringLength(191);

标签:violation,max,long,1071,access,key,42000
From: https://www.cnblogs.com/nojiwai/p/17017978.html

相关文章