0

MySQL Specified key was too long; max key length is 767 bytes

athena 发布于2年前 阅读数 2272

MySQL 建索引报错。 SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes (SQL: alter table deals add unique index _time_link(start_time, link))

举报
回复
0
set global innodb_large_prefix=on;
set global innodb_file_format=Barracuda;
2年前 回复
0

字段名太长, 建立下短一点的字段。

2年前 回复