$sql_1="create table table_one ( id int not null auto_increment primary key, name char(20));"; $sql_1="create table table_two ( id int not null auto_increment primary key, name char(20))"; $sql_1="insert into table_one (name) values ('11'), ('22'), ('33')"; $sql_1="insert into table_two (name) values ('aa'), ('bb'), ('cc')"; $sql_1="create table summ_table ( id int not null auto_increment, name char(20), index(id)) type=merge union=(table_one,table_two) insert_method=last"; Taken with Types and Structure of Tables in MySQL . Why a mistake
You have an error in your SQL syntax; check the syntax for the right syntax to use the 'link =' table_one, table_two} insert_method = last 'at line 4
I only guess, maybe my version does not support this feature.
