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;

Leave a Reply

Your email address will not be published.