MySQL generate mysql create command

MySQL can automatically output the command necessary to create a duplicate table. Very useful for copying tables between servers or for doing small modifications between two tables.


SHOW CREATE table table_name;