首页 > 建站教程 > 数据库 >  MYSQL报错:#1089 - Incorrect prefix key; the used key part isn'正文

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

我爱模板网通过phpMyAdmin新建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

截图如下:



原来,在设置id为索引时,不小心填写了后面的大小,导致的错误,将大小留空即可: