Get MySQL table schema for a dump
| From: | Jonathan Villa | Date: | Wed, 26 Feb 2003 23:23:57 +0000 |
| Subject: | Get MySQL table schema for a dump | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-25934@lists.php.net to get a copy of this message | ||
Is there was to get a database's table schema?
For example, I want to be able to click on a link and then create a .txt
file of a table (or even better a databases) schema.
So far, I have a simple function which will output
INSERT INTO table (x,x,x,) VALUES(x,x,x);
INSERT INTO table (x,x,x,) VALUES(x,x,x);
INSERT INTO table (x,x,x,) VALUES(x,x,x);
INSERT INTO table (x,x,x,) VALUES(x,x,x);
etc.
but what I'm missing is
CREATE table blah, blah, blah
**that is what I want to get.
-Jonathan