php - mysql无法执行user_id

Question

这里有一张我制作 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

[ 1

在这里您可以在 SQL 编辑器中看到错误的样子，这将是描述底部的代码(SQL 查询代码)

CREATE TABLE `User_System`.`usersystem` (
    `user_id` INT(11) NOT NULL AUTO_INCREMENT ,
    `username` VARCHAR(25) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ,
    `password` VARCHAR(1024) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ,
    `first_name` VARCHAR(40) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ,
    `last_name` VARCHAR(40) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ,
    `active` INT(10) NOT NULL DEFAULT '0' ,
    PRIMARY KEY (`user_id`(11)))
ENGINE = InnoDB CHARACTER SET latin1 COLLATE latin1_swedish_ci
COMMENT = 'User login and register';

Answer 1

从您的主键定义中删除 (11)。键应该只包含列名，而不是它们的类型或大小