"Dathan Vance Pattishall" <[EMAIL PROTECTED]> wrote: > SHOW TABLE STATUS to get the count of each table, then your application = > adds > the number in the Rows field from each of the tables returned.
For InnoDB tables SHOW TABLE STATUS returns approximate row count. > > >> -----Original Message----- >> From: Gustavo Andrade [mailto:[EMAIL PROTECTED] >> Sent: Sunday, May 16, 2004 3:10 PM >> To: [EMAIL PROTECTED] >> Subject: Counting multiple tables >> I want to know if its possible to count the total records of multiple >> tables: >> Example: I have 3 tables. I want to know the total records of each = > table >> using only 1 query. >> Is that possible? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]