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

Question

up vote 1 down vote favorite

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.

flag	asked Aug 12 '09 at 2:45 zak23 445310 50% accept rate

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

up vote 4 down vote accepted

This should work:


SHOW CREATE TABLE tbl_name

You should have SELECT privileges for the table.

answered Aug 12 '09 at 2:50

Freddy
1,080112

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

up vote 7 down vote

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 '09 at 3:14

gahooa
9,2851119

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

2 Answers

Your Answer

Not the answer you're looking for? Browse other questions tagged mysql mysql-query mysqldump or ask your own question.

Hello World!

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

2 Answers

Your Answer

Not the answer you're looking for? Browse other questions tagged mysql mysql-query mysqldump or ask your own question.

Hello World!

Related