query counts of a database

2008-06-13 Thread Elim Qiu
I'm looking for a query that reports the count of each table in the database. the query should not assume the table list of the database. Thanks for any inputs -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

RE: query counts of a database

2008-06-13 Thread Boyd, Todd M.
-Original Message- From: Elim Qiu [mailto:[EMAIL PROTECTED] Sent: Friday, June 13, 2008 10:56 AM To: mysql@lists.mysql.com Subject: query counts of a database I'm looking for a query that reports the count of each table in the database. the query should not assume the table list

RE: query counts of a database

2008-06-13 Thread Rolando Edwards
] Sent: Friday, June 13, 2008 11:56 AM To: mysql@lists.mysql.com Subject: query counts of a database I'm looking for a query that reports the count of each table in the database. the query should not assume the table list of the database. Thanks for any inputs -- MySQL General Mailing List

Re: query counts of a database

2008-06-13 Thread Elim Qiu
PROTECTED] To: Elim Qiu [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Friday, June 13, 2008 10:02 AM Subject: RE: query counts of a database -Original Message- From: Elim Qiu [mailto:[EMAIL PROTECTED] Sent: Friday, June 13, 2008 10:56 AM To: mysql@lists.mysql.com Subject: query counts

Re: query counts of a database

2008-06-13 Thread Elim Qiu
Thanks a lot Edwards! I'm using MySQL 5.1. Your query works great! - Original Message - From: Rolando Edwards [EMAIL PROTECTED] To: Elim Qiu [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Friday, June 13, 2008 10:32 AM Subject: RE: query counts of a database If you are using MySQL 5.0