Would UNION help? Something like this: select count(ID) as Total from categories where ID > 5 UNION select count(ID) as Total from products where ID > 5 UNION select count(ID) as Total from systems where ID > 5
Then you could just sum Total? > -----Original Message----- > They do not... But I think I will just re-write my script in php > command line and loop through it. > It was just that I loved the simplicity of the bash script. > > >>Getting closer.... Thanks... > >>This db had LOTS of tables... That's why I'm simply trying > to get the > >>total. > >>Is there a way to only get one column of this. then I can > do something > >>like select SUM(show table status (rows)); > >> > >> > > > >IF all the tables have the same table structure, create a > MERGE table of > >them all, then SELECT count(*) FROM merged ; > > > > Alec -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
