Error 1089: Incorrect prefix key; the used key part isn't a string, the used length is longer than t
Error Code
SQLSTATE
Error
Description
1089
HY000
ER_WRONG_SUB_KEY
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
Possible Causes and Solutions
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
PreviousError 1088: Records DuplicatesNextError 1090: You can't delete all columns with ALTER TABLE; use DROP TABLE instead
Last updated
Was this helpful?