How to create duplicate table using existing table structure

2001-01-26 Thread Subba Reddy M
I have tried as MySQL documentation help to create one duplicate table using existing table structure. But, It's raise error. i.e., create table select * from ; mysql> mysql> create table works SELECT * FROM t_Works; ERROR 1064: You have an error in your SQL syntax near 'SELECT * FROM t_Work

How can I create one more table with existing table structure

2001-01-26 Thread Subba Reddy M
Hello MySQL guru, Please advise me, on creating new table with existing table structure. I have tried, how MySQL documentation referred, but unable to get success. create table newtable select * from oldtable;