0

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

MySQL
athena created at6 years ago view count: 2413

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
lucy # 
set global innodb_large_prefix=on;
set global innodb_file_format=Barracuda;
6 years ago 回复
0
jeo #

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

6 years ago 回复

Recommend

相关搜索关键词

Recent search keywords