ibm ilog mysql_mysql建表一直报错,看着没啥问题啊,来个大哥看下,谢谢

DROPTABLEIFEXISTS`demo`;CREATETABLE`demo`(`id`varchar(50)CHARACTERSETutf8COLLATEutf8_general_ciNOTNULLCOMMENT'主键ID',`name`varchar(30)CHARACTERSETutf8COLLATEutf8_general...

DROP TABLE IF EXISTS `demo`;

CREATE TABLE `demo` (

`id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键ID',

`name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名',

`key_word` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '关键词',

`punch_time` datetime(0) NULL DEFAULT NULL COMMENT '打卡时间',

`salary_money` decimal(10, 3) NULL DEFAULT NULL COMMENT '工资',

`bonus_money` double(10, 2) NULL DEFAULT NULL COMMENT '奖金',

`sex` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性别 {男:1,女:2}',

`age` int(11) NULL DEFAULT NULL COMMENT '年龄',

`birthday` date NULL DEFAULT NULL COMMENT '生日',

`email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',

`content` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '个人简介',

`create_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',

`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',

`update_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人',

`update_time` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',

`sys_org_code` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属部门编码',

PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

报错信息:

[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 '(255) NULL DEFAULT NULL COMMENT '打卡时间',

`sex` varchar(2) CHARACTER ' at line 5

展开