How to show MYSQL statements that show how to create a particular table?

Question

Hi,

I've created and edited a couple of tables and don't want to recreate them from scratch if the database gets erased. What command allows me to "export" the field names and settings (NOT the content) as a ready to use MYSQL command that I can paste back on the MYSQL prompt?

Answer 1

SHOW CREATE TABLE tablename;

Reference: mySQL docs