Get MySQL table schema for a dump

From: 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

« previous php.db (#25934) next »