SQL查询:CREATETABLE`test`.`user`(`id`INT(5)NOTNULLAUTO_INCREMENTPRIMARYKEY,`name`CHAR(10)CHARACTERSETutf8COLLATEutf8_general_ciNOTNULL,`password`CHAR(12)CHARACTERSETutf8C...
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
这是错误结果,大家帮忙看下问题在哪里
展开