RE: [PHP-DB] Get MySQL table schema for a dump

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