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
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;