1insert into tt (id) values (1),(2),(3) on duplicate key update x = 0; 2insert into tt (id) values (1) on duplicate key update y = 0, z = 42; 3insert into tt (id) values (1) on duplicate key update y = y + 1, z = z + 50; 4insert into tt (id) values (1) on duplicate key update y = y - 1; 5insert into tt (id) values (1) on duplicate key update z = z - 50; 6 7create table ti like tt; 8alter table ti engine=innodb; 9insert into ti (id) values (1),(2),(3) on duplicate key update x = 0; 10insert into ti (id) values (1) on duplicate key update y = 0, z = 42; 11insert into ti (id) values (1) on duplicate key update y = y + 1, z = z + 50; 12insert into ti (id) values (1) on duplicate key update y = y - 1; 13insert into ti (id) values (1) on duplicate key update z = z - 50; 14 15let $diff_tables = test.tt, test.ti; 16source include/diff_tables.inc; 17 18drop table tt, ti; 19 20