Is it possible to pull a table's create syntax via mysql?

Question

I'm looking to pull a table's create syntax via mysql and php. Is it possible?

I need it for a file that creates table_x automatically every 10 days. Since I update the site constantly and create new fields I'd like the file to be dynamic and use the previous table (instead of me updating it manually each time).

What happens if you need to recreate your database from scratch? — Oliver Charlesworth
– Oliver Charlesworth, Commented Nov 24, 2011 at 1:29
I understand your point, but I don't see why I would need to do that. I'd be able to copy the syntax from a backup. — domino
– domino, Commented Nov 24, 2011 at 1:38

Adrian Cornish · Accepted Answer · 2011-11-24 01:40:18Z

2

Yes you can - use

SHOW CREATE TABLE tablename;

Actually if you want to 'reset' your database I would use TRUNCATE instead

TRUNCATE TABLE tablename

edited Nov 24, 2011 at 1:40

answered Nov 24, 2011 at 1:31

Adrian Cornish

24k13 gold badges64 silver badges81 bronze badges

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

2 Comments

domino Over a year ago

Thanks, had no idea it was that simple.

Adrian Cornish Over a year ago

:-) cool when it does what you want - also checkout TRUNCATE TABLE (added to my answer) it may be more of what you want

Thomas Kelley · Accepted Answer · 2011-11-24 01:32:26Z

0

SHOW CREATE TABLE table_x;

...will output one record with the CREATE syntax. Is that what you're looking for?

answered Nov 24, 2011 at 1:32

Thomas Kelley

10.3k1 gold badge38 silver badges43 bronze badges

Collectives™ on Stack Overflow

Is it possible to pull a table's create syntax via mysql?

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related