Laravel 运行 migrate 命令的时,错误信息为1071 Specified key was too long的解决办法
Laravel 中运行 php artisan migrate
迁移命令时,报错:“SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes”
解决方法:在服务提供者 AppServiceProvider
的 boot()
中调用 Schema::defaultStringLength()
方法来进行配置,代码如下:
use Illuminate\Support\Facades\Schema;
/**
* Bootstrap any application services.
*
* @return void
*
*/
public function boot()
{
Schema::defaultStringLength(191);
}