anyway to create a table

sfullman

I know descrbe table in mysql.

Is there anyway to return the actual CREATE TABLE string that would create the given table, or do I need to run DESCRIBE table [name], parse it out, and build the CREATE command.

I'm wanting to copy a table quickly, to another equal table with a different name.

Thanks,
Sam

barand

At command prompt

mysqldump -d databasename tablename

The -d gives structure only, no data

hth

sfullman

quite cool. No native SQL command to do same?

NOTE:
Doesn't work on my linux 7.3 box, with mysql 3.23. Do I need to be in a certain directory for the command to be recognized? Sorry I don't know linux better than that.

Sam

barand

'fraid I can't help there - I'm on windoze.

LordShryku

SHOW CREATE TABLE table_name

tomhath

No need to even know what the old table structure is:

CREATE TABLE new_tbl SELECT * FROM orig_tbl;

http://www.mysql.com/doc/en/CREATE_TABLE.html