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 -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 uses, it returns the SQL statements for creating > the databases. > > I want the following for all tables in one shot? > > mysql> describe products; > +-------------+----------------------+------+-----+---------+----------------+ > > | Field | Type | Null | Key | Default | > Extra | > +-------------+----------------------+------+-----+---------+----------------+ > > | ProductID | smallint(5) unsigned | | PRI | NULL | > auto_increment | > | iLgImage | smallint(6) unsigned | YES | | NULL > | | > | iSmImage | tinyint(4) unsigned | YES | | NULL > | | > | Description | varchar(255) | YES | MUL | NULL > | | > | ProductName | varchar(64) | YES | MUL | NULL > | | > +-------------+----------------------+------+-----+---------+----------------+ > > 5 rows in set (0.00 sec) > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
