CREATE TABLE `health` ( `id` VARCHAR(32) NOT NULL , `group_id` VARCHAR(32) NOT NULL COMMENT '事业单位id', `perfect` INTEGER NULL COMMENT '完美', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='test';
mysql创建表varchar类型不给长度会报错,今天遇到这个问题,记录一下。
报错:
[Err] 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 'NULL COMMENT
下面这种也是不符号语法规则的,表名属性名应该用这个符号“`”,不能用引号
CREATE TABLE "work_area" ( "id" VARCHAR NOT NULL COMMENT 'testid', "name" VARCHAR NULL COMMENT 'testname', PRIMARY KEY ("id") );