CREATE TABLE auction_user
(user_id
int(11) NOT NULL COMMENT '用户id',user_name
varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名',user_pwd
varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户密码',user_email
varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户email',user_phone
varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '手机号',
PRIMARY KEY (user_id
) USING BTREE,
UNIQUE INDEX 1
(user_name
) USING BTREE COMMENT '用户名不可重复'
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户表' ROW_FORMAT = Compact;
错误信息不完整啊,应该有提示的
UNIQUE INDEX 1(user_name) 这个1啥意思,去掉1