create table m (a int, f varchar(10)) ENGINE=MyISAM; insert into m VALUES (1,'a'), (2,'b'), (3,'c'), (4,'d'); insert into m SELECT m.* from m m, m mx; insert into m SELECT m.* from m m, m mx; --exec $MYSQL_TEST_DIR/../storage/myisam/myisampack $MYSQL_TEST_DIR/var/master-data/test/m.MYI create table m2 (a int, f varchar(10)) ENGINE=MyISAM; create table mm (a int, f varchar(10)) engine=MERGE UNION=(m,m2) INSERT_METHOD=LAST; select * from mm limit 5;