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")
);