CREATE table op_history(
`id` BIGINT UNSIGNED not NULL AUTO_INCREMENT COMMENT '操作id',
`create_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
PRIMARY key `id`
)ENGINE=InnoDB
PARTITION by KEY(`create_date`) PARTITIONS 3;
---------------------------------------------------------------------------
在navicat里面，执行上述sql后，报错了，可是语法看不出有什么问题啊。。？
请各位大神指点迷津。（数据库用的是mysql5.7）
[SQL] CREATE table op_history(
`id` BIGINT UNSIGNED not NULL AUTO_INCREMENT COMMENT '操作id',
`create_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
PRIMARY key `id`
)ENGINE=InnoDB
PARTITION by KEY(`id`) PARTITIONS 3;
[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 ')ENGINE=InnoDB
PARTITION by KEY(`id`) PARTITIONS 3' at line 5
