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.
DVP ---- Dathan Vance Pattishall http://www.friendster.com > -----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? > > _________________________________________________ > Quer ter um fórum para seu clan de Starcraft/BroodWar, Counter-Strike, > Warcraft ou outros. entre em > http://www.arena-star.com.br/forum/ > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]