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