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 ||| mai
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
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:
A fellow in our shop wrote a perl script to do just that.
Enjoy!
Andy
Andy Ingham
Systems Librarian
Academic Affairs Library
UNC-Chapel Hill
919-962-1288
[EMAIL PROTECTED]
*
#!/usr/local/bi
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 d
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
>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
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.
>
