Copy contents of one table to another-Mysql
by Mohan[ Edit ] 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.
