[Err] 1064 - You have an error in your SQL syntax;

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;

img

错误信息不完整啊,应该有提示的

UNIQUE INDEX 1(user_name) 这个1啥意思,去掉1