mysql duplicate table definition

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

create table table2 like table1;

Written by Knilluz on 17 April 2012 at 11:17