Check out mysqldump.
Michael Collins wrote:
Can describe be used to show columns from all tables in a database?
All at once that is. I want to document all fields in all tables and
find I need to display one table at a time.
From: Michael Collins [mailto:[EMAIL PROTECTED]]
Can describe be used to show columns from all tables in a database?
At 9:56 AM -0800 1/28/02, Bruce Sandell wrote:
try mysqldump with the -d option.
That was my first thought, but this does not give a result in the
nice tables wish describe
Crack the Perl book. A script to do this using SHOW DATABASES and
SHOW TABLES to get the lists would be fairly trivial to write.
james montebello
On Mon, 28 Jan 2002, Michael Collins wrote:
From: Michael Collins [mailto:[EMAIL PROTECTED]]
Can describe be used to show columns from all
At 11:33 -0800 1/28/02, Michael Collins wrote:
From: Michael Collins [mailto:[EMAIL PROTECTED]]
Can describe be used to show columns from all tables in a database?
At 9:56 AM -0800 1/28/02, Bruce Sandell wrote:
try mysqldump with the -d option.
That was my first thought, but this does not give
-disconnect;
exit;
*
--- Original message --
Subject: describe all tables
Date: Sun, 27 Jan 2002 18:52:04 -0800
From: Michael Collins [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Can
You can write a shell script that does:
mysqlshow database, and then loops throught the tables returned doing:
mysqlshow database table
Michael Collins wrote:
From: Michael Collins [mailto:[EMAIL PROTECTED]]
Can describe be used to show columns from all tables in a database?
At 9:56 AM
bash-2.04$ for i in `mysql mysql -e 'show tables;'`; do mysql mysql -e describe
$i;; done
Assuming bash as the shell, and os as UNIX, of course...
Regards,
Van
--
=
Linux rocks!!! http://www.dedserius.com/
At 1:46 PM -0600 1/28/02, Paul DuBois wrote:
I'd write a script that issued SHOW TABLES, then a DESCRIBE for each
table.
Thanks for the suggestion, I know some of the workarounds, I am
looking for the shortcut. Consider this as a feature request: allow
for describe to take a wildcard for the
At 2:54 PM -0500 1/28/02, Andy Ingham wrote:
A fellow in our shop wrote a perl script to do just that.
Nice but I do not think I have perl DBI library installed. Does it
have to be compiled in? I am on Mac OS X
--
Michael
__
||| Michael Collins |||
||| Kuwago Web Services |||
Can describe be used to show columns from all tables in a database?
All at once that is. I want to document all fields in all tables and
find I need to display one table at a time.
--
Michael
__
||| Michael Collins |||
||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED]
|||
10 matches
Mail list logo