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 <newtable> select * from <oldtable>;

mysql>
mysql> create table  works SELECT * FROM t_Works;
ERROR 1064: You have an error in your SQL syntax near 'SELECT * FROM t_Works' at
 line 1
mysql>


Please help in this regards.

Thanks in advance,

SubbaReddy

Reply via email to