标题: mysql分区必须先创建好,才能insert数据吗? [打印本页] 作者: habwn 时间: 2014-4-10 13:41 标题: mysql分区必须先创建好,才能insert数据吗? 我先创建了几个分区, 然后4月1号以后的还没来得及创建,当插入4月1号的数据时,就报出这样的信息了:Table has no partition for value 735721,必须先创建好分区,才能插入数据吗? PARTITION p_20140327 VALUES LESS THAN (TO_DAYS('2014-03-28')), PARTITION p_20140328 VALUES LESS THAN (TO_DAYS('2014-03-29')),
PARTITION p_20140329 VALUES LESS THAN (TO_DAYS('2014-03-30')),
PARTITION p_20140330 VALUES LESS THAN (TO_DAYS('2014-03-31')),
PARTITION p_20140331 VALUES LESS THAN (TO_DAYS('2014-04-01'))