Just use SHOW CREATE TABLE
SHOW CREATE TABLE my_tableSee 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/
Convert your data online, free
Free in-browser converters for CSV, Excel, JSON, XML and SQL: Withdata Online Data Conversion. Large files, batch conversion or scheduling? See the offline desktop apps, or browse all data conversion tools.
