22,210
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE `tt` (
`id` int(11) NOT NULL,
`u_id` int(11) NOT NULL,
`date` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `u_id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
/*!50100 PARTITION BY RANGE (id)
(PARTITION p1 VALUES LESS THAN (1000) ENGINE = MyISAM,
PARTITION p2 VALUES LESS THAN (5000) ENGINE = MyISAM) */
CREATE TABLE `tt` (
`id` int(11) NOT NULL,
`u_id` int(11) NOT NULL,
`date` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `u_id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
PARTITION BY RANGE (id)
(PARTITION p1 VALUES LESS THAN (1000) ENGINE = MyISAM,
PARTITION p2 VALUES LESS THAN (5000) ENGINE = MyISAM)
;
这样直接执行没问题啊