I have a MySQL database with table names like
1,2,3... upto 1000
Each tables have
2000 rows and has the same structure.
This is how all my 2000 table's structure look like
id has type int, primary key,auto increment.
Now I would like to create a new database with name
merged. Also a table with name
Can someone tell me how to import all my tables in
My problem here is all my tables has
1 to 2000. So I have no idea how to import them.
I would like to have unique ids from
1 to 2000000 in my new
I'm using ubuntu. So if someone suggest me a terminal command, that would be awesome.