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
-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
]
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
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
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