> 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.

SHOW CREATE TABLE <table_name>;

---John W. Holmes...

PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to