I have tried these sql statements and its just not working.I am trying to create a table and keep the same data and structure as table1.
I have tried
create table table1 like table2<<<Keeps the same structure but no data
insert into table1(select * from table2) <<<< Keeps crashing the new table
and then I tried create table table1(select * from table2)<<< retrieves the data but not the structure such as primary keys etc.