Home>
$ 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 from Types and structure of tables in MySQL... Why error

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'type= merge union= (table_one, table_two) insert_method= last' at line 4

I have only guesses -maybe my version does not support this function.

Did it help. Make the answer to close. Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist phpAdmin type doesn't support them?

koza4ok2021-02-23 05:25:45
  • Answer # 1

    Sotype= mergeorengine= merge?