CREATE TABLE t1 (i INT) ENGINE=MyISAM PARTITION BY RANGE (i) ( PARTITION p00 VALUES LESS THAN (1), PARTITION p01 VALUES LESS THAN (2) ); INSERT IGNORE INTO t1 VALUES (3); Warnings: Warning 1526 Table has no partition for value 3 DROP TABLE t1;