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
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/
=
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:
| Key | Default| Extra |'."\n";
print OUTFILE
'+--+-+--+-+++'."\n";
while(my ($fld, $type, $nul, $key, $dft, $xtra) =
$select_sth->fetchrow() ){
printf OUTFILE "|%-18s|%-33s|%-6s|%-5s|%-12s|%-16s|\n", $fld, $type,
$nul, $key, $df
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.
>
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]
||| Sea
10 matches
Mail list logo
