How to copy content of one table to another table ?

[Dipak Bhoi]

Hello folks,

I found a new and simple way to copy content of one table to another table within same database using command prompt. You can copy/duplicate one table to new table at the time to creating new table.

Go to mysql prompt and switch to the database in which you wish to copy/duplicate table.

mysql> use database_name;

mysql> CREATE TABLE new_table_name SELECT * FROM old_table_name;

Above CREATE TABLE command will create a new_table_name' like table 'old_table_name' and entire data from old table will be copied to new table. You can break this operation into two steps as well. Let see below two command which will perform same operation.

mysql>CREATE TABLE new_table_name LIKE old_table_name;

myslq>INSERT INTO new_table_name SELECT * FROM `old_table_name`;

Using above commands you can create new table like old table and then copy entire data of old table into new table.

Hope this post will help..

That's all....... Enjoy !!