Question

MYSQL数据库建表不成功

SQL 查询:
CREATETABLE`test`.`user`(`id`INT(5)NOTNULLAUTO_INCREMENTPRIMARYKEY,
`name`CHAR(10)CHARACTERSETutf8COLLATEutf8_general_ciNOTNULL,
`password`CHAR(12)CHARACTERSETutf8COLLATEutf8_general_ciNOTNULL,
`studentid`CHAR(9)CHARACTERSETutf8COLLATEutf8_general_ciNOTNULL,
`studentname`CHAR(10)CHARACTERSETutf8COLLATEutf8_general_ciNOTNULL,
`phone`CHAR(11)CHARACTERSETutf8COLLATEutf8_general_ciNOTNULL,
`userstate`BOOL(1)NOTNULL)ENGINE=InnoDBCHARACTERSETutf8COLLATEutf8_general_ciMySQL 返回：#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(1) NOT NULL) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci' at line 1

这是错误结果，大家帮忙看下问题在哪里

若以下回答无法解决问题，邀请你更新回答

Answer 1

如果你确定语句是对的，那么就是设置的问题！

Answer 2

注意空格了没有？

追问

我是在数据库界面中点选项操作的，上面是执行之后自动生成的代码

追答

汗。是界面的就直接就新建表了啦，怎么还会生成代码？ 在界面新建表不是so easy的么

Answer 3

语法有问题，检查下你的SQL语句

Answer 4

MYSQL语法错误