--disable_warnings DROP TABLE IF EXISTS t1; --enable_warnings SET SESSION storage_engine= MyISAM; CREATE TABLE t1 ( f_int1 INTEGER, f_int2 INTEGER, PRIMARY KEY (f_int1)) PARTITION BY HASH(f_int1) PARTITIONS 2; INSERT INTO t1(f_int1,f_int2) VALUES(1,1),(2,2); ## REPLACE REPLACE INTO t1 (f_int1, f_int2) VALUES(1,1),(2,2); SELECT 1;