How do I merge 5 identical MySQL tables? -

i want merge 5 identical-schema (okay, not identical can edit field names make them identical) mysql databases 1 database. there easy way?

create table `users` (     `name` varchar (50) collate utf8_turkish_ci default null,     `surname` varchar (50) collate utf8_turkish_ci default null,     `telephone` varchar (50) collate utf8_turkish_ci default null,     primary key (`id`),  ) engine = myisam auto_increment = 1000 default charset = utf8 collate = utf8_turkish_ci pack_keys = 0 row_format = dynamic 

if tables same column names/types , named

• user1
• user2
• user3
• user4
• user5

there 2 approaches handle this:

approach #1 : load data 1 table

create table user user1; insert user (name,surname,telephone,...) select name,surname,telephone,... user1; insert user (name,surname,telephone,...) select name,surname,telephone,... user2; insert user (name,surname,telephone,...) select name,surname,telephone,... user3; insert user (name,surname,telephone,...) select name,surname,telephone,... user4; insert user (name,surname,telephone,...) select name,surname,telephone,... user5; 

if id auto_increment rows new ids.

approach #2 : use merge storage engine

create table user user1; alter table user     engine=mrg_myisam     union=(user1,user2,user3,user4,user5) ; 

give try !!!