MySQL CREATE TABLE syntax from existing table

A short MySQL tip: SHOW CREATE TABLE [table_name] in MySQL will give you the SQL to create table_name is another database, including all indexes.