MySQL Rocks!

Wow I just found a really cool feature!  You can copy and entire table and all the data from one table to another in MySQL very easily!

CREATE TABLE newtable SELECT * FROM oldtable;

Done!  Or if you JUST want to copy the table structure:

CREATE TABLE newtable SELECT * FROM oldtable WHERE 1=0;



Note: Replies will be formatted with PHP Markdown Extra syntax.

Name: Email (Not Required):
 
Logged IP: 3.236.52.68
To prevent spam please submit by clicking the kitten: