Copy contents of one table to another-Mysql

by Mohan 2014-02-26 18:23:55


<h1>
Mysql Copy table content to another table
</h1>

Here is a sample code to copy all contents of a table to another table without using insert query.


CREATE TABLE new_table SELECT * FROM older_table;


A table named new_table will be created with contents of older_table.

Tagged in:

598
like
0
dislike
0
mail
flag

You must LOGIN to add comments