> -----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 of the database. > > Thanks for any inputs
Is "SELECT COUNT(*) FROM *" too open-ended? BTW... do you want the number of records per table, or number of tables per database?? Todd Boyd Web Programmer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]