Eternal Night

Tagged: 索引长度限制

在执行数据库迁移时，报错：SQLSTATE[42000]: Syntax error or access violation: 1059 Identifier name 'theme_installation_version_preset_theme_store_theme_version_id_index' is too long 0

Database / Web Framework / MySQL / Laravel / MySQL 5.7 / Laravel 6 / Laravel Database Migrations / Web Application Development

In database migration in Laravel 6, SQLState[42000]: Syntax Error or Access Violation: 1059 Identifier nametheme_installation_version_preset_theme_store_theme_version_id_indexis too long

浏览量： 2 1. When performing database migration, an error is reported: sqlstate[42000]: Syntax Error or Access Violation: 1059 Identifier nametheme_installation_version_preset_theme_store_theme_version_id_indexis too long. as shown in Figure 1 The index length limit of MySQL 5.7...