How to generate a CREATE TABLE statement for a given table in Mysql

by

Posted on by

Just use SHOW CREATE TABLE

SHOW CREATE TABLE my_table

See also:

How to generate a CREATE TABLE statement for a given table in SQL Server

How to generate a CREATE TABLE statement for a given table in Oracle

How to generate a CREATE TABLE statement for a given table in SQLite

Some MySQL tools you can try: https://www.withdata.com/mysql/