mysql分区语法错误

Question

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
 

 

Answer 1