Heya folks --
Trying to come up with a way to count across multiple tables, and failing
miserably. I need a simple way, preferably better than looped queries, of
summing the number of rows in multiple tables.
Example:
I have multiple tables with the same column layout, due to the amount of data
expected to land in each one, broken up by year/month. This is simplified
some, but should serve to illustrate the issue.
create table info_2004_03 (
itemID integer auto_increment NOT NULL,
eventID integer NOT NULL,
eventName char(40),
primary key (itemID)
);
create table info_2004_04 (
itemID integer auto_increment NOT NULL,
eventID integer NOT NULL,
eventName char(40),
primary key (itemID)
);
I need to get a total number of itemIDs over all the info_ tables. I could just
query each of the tables individually and add the results, but looking for a
more graceful way of doing it, hopefully.
Thanks in advance!
ken
===========================================================================
"Diplomacy is the weapon of the Civilized Warrior"
- Hun, A.T.
Ken Gieselman [EMAIL PROTECTED]
System Administrator http://www.endlessknot.com/~ken
Endlessknot Communications http://www.endlessknot.com
===========================================================================
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]