mysql duplicate table definition

To create a table with the same definition as an already existing table:

create table table2 like table1;