[SOLVED] copy a table

[asmith]

create table database2.table2 like database1.table1
insert into database2.table2 select * from database1.table1 

 

i found this over the net to copying a table from one data base to another , is it the shortest way ? can i do it with only one line ?

[Barand]

If you don't need the indexes and just want to copy the data

 

create table database2.table2 select * from database1.table1 

[asmith]

no , i'm just testing a table with values, so after a while  i just want to reset it to the previous values it had. so i want to make a copy of it somewhere and ...

thanks so much for the code ! solved !

[fenway]

If you don't need the indexes and just want to copy the data

 

create table database2.table2 select * from database1.table1 

Did this always work? I don't know that I've ever seen it.