Table Copy

[jenniferG]

Is there an esy way to  copy a table schemna to a new table in mysql?  We can certainly

build a new tasble, but would like to copy schema.

 

Jennifer

[Illusion]

CREATE TABLE new_tbl LIKE old_tbl;

 

 

[fenway]

CREATE TABLE new_tbl LIKE old_tbl;

 

 

Only from a certain version, though....