use test;

drop table if exists base_table;
drop table if exists merge_table;

CREATE TABLE `base_table` (
  `id` int(10) NOT NULL auto_increment primary key
) ENGINE=MyISAM;

CREATE TABLE `merge_table` (
  `id` int(10) NOT NULL auto_increment primary key
) ENGINE=MRG_MyISAM INSERT_METHOD=LAST UNION=(`base_table`);

ALTER TABLE base_table AUTO_INCREMENT=1000;

FLUSH TABLES;

INSERT into merge_table values ();

SELECT * from merge_table;

INSERT into base_table values ();

SELECT * from merge_table;

INSERT into merge_table values ();

SELECT * from merge_table;