generate a "create table" sql command based on an existing table in mysql

Question

I have a mysql shell but for security reasons I cannot run the mysqldump command.

I have a table that I made a while ago with a lot of columns, and I want to generate a new "create table" command to create that table on a different database.

Is there some command I can run in the mysql shell to generate that?

Thanks.

Freddy · Accepted Answer · 2009-08-12 02:50:23Z

17

This should work:


SHOW CREATE TABLE tbl_name

You should have SELECT privileges for the table.

answered Aug 12, 2009 at 2:50

Freddy

3,3243 gold badges28 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

gahooa · Accepted Answer · 2009-08-12 03:14:24Z

15

FYI, if your user has access to both databases on the same server, you can do this:

CREATE TABLE db2.tablename LIKE db1.tablename;

answered Aug 12, 2009 at 3:14

gahooa

138k14 gold badges101 silver badges104 bronze badges

Collectives™ on Stack Overflow

generate a "create table" sql command based on an existing table in mysql

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related