MySQL CREATE TABLE syntax from existing table

A short MySQL tip: SHOW CREATE TABLE [table_name] in MySQL will give you the SQL to create table_name is another database, including all indexes.


No comments yet. Why don’t you start the discussion?

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.