0

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

athena created at5 years ago view count: 2381

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))

report
回复
0
set global innodb_large_prefix=on;
set global innodb_file_format=Barracuda;
5 years ago 回复
0

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

5 years ago 回复