Specified key was too long max key length is 1000 bytes
程序员文章站
2022-03-23 11:18:37
Mysql建立索引时遇到一个问题就是索引字段长度太长，解决办法： 1.修改字段长度 ； 2.修改mysql默认的存储引擎 ，修改为INNODB； https://www.2cto.com/database/201211/167561.html ......
Mysql建立索引时遇到一个问题就是索引字段长度太长，解决办法：
1.修改字段长度 ；
2.修改mysql默认的存储引擎 ，修改为INNODB；
https://www.2cto.com/database/201211/167561.html
推荐阅读
-
mysql建库时提示Specified key was too long max key length is 1000 bytes的问题的解决方法
-
MySQL错误“Specified key was too long; max key length is 1000 bytes”的解决办法
-
MySQL错误“Specified key was too long; max key length is 1000 bytes”的解决办法
-
ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes
-
Laravel 5.4中migrate报错: Specified key was too long error的解决
-
peewee.InternalError: (1071, 'Specified key was too long; max key length is 1000 bytes')
-
Specified key was too long max key length is 1000 bytes
-
ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes
-
MySQL错误“Specified key was too long; max key length is 100
-
Laravel 5.4中migrate报错: Specified key was too long error的解决