MySql在执行脚本时,报出了以下错误:
index column size too large. the maximum column size is 767 bytes
1.检查innodb_large_prefix
show variables like 'innodb_large_prefix';
show variables like 'innodb_file_format';
show variables like 'innodb_file_per_table';
set global innodb_large_prefix=1;
set global innodb_file_format=BARRACUDA;
set global innodb_file_per_table=1;
2.修改表 row_format=dynamic
- 查询
SELECT *
FROM information_schema.TABLES
WHERE TABLE_SCHEMA='数据库名' AND TABLE_NAME='表名';
- 修改
ALTER TABLE 数据库名.表名 row_format =dynamic;