CREATE TABLE `movies`.`movie`
( `movie_id` INT(3) NULL AUTO_INCREMENT, `movie_name` VARCHAR(25) NULL,
`movie_embedded_id` VARCHAR(50) NULL, `rating_no` INT(3) NULL,
`movie_description` VARCHAR(50) NULL, PRIMARY KEY (`movie_id`(3))) ENGINE = InnoDB;
我不断收到此错误:
#1089 - 不正确的前缀键;使用的关键部分不是字符串,使用的长度比关键部分长,或者存储引擎没有支持唯一前缀键.
#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.
但我不知道这是什么意思,有人知道吗?
but I've got no idea what it means, anyone have a clue?
同部分
PRIMARY KEY (`movie_id`(3))
您告诉 mysql 在电影 ID 的前 3 个字节上创建一个 子部分键*.这仅适用于字符串类型.
you are telling mysql to create a sub part key* on the first 3 Bytes of movie id. This only works for string types.
你需要使用
PRIMARY KEY (`movie_id`)
不提供长度.
*这确定是查询导致错误吗?从来没有在主键上看到过,它用于索引.
*Is this sure the query resulting in the error? Never saw that on a primary key, its used for indexes.
这篇关于我不断收到此 mysql 错误代码 #1089的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!