MYSQL报错:#1089 - Incorrect prefix key; the used key part isn't a string

MYSQL报错:#1089 - Incorrect prefix key; the used key part isn't a string, the used length is longer than the key part, or the storage engine doesn't support unique prefix keys

解决办法:

添加索引时大小不要设置即可

posted @ 2019-12-09 11:44  collin-liu  阅读(3596)  评论(0编辑  收藏  举报