Re: count() on multiple similar tables?

2004-05-04 Thread Ken Gieselman
Great! Thanks for the quick pointer! ken Quoting Diana Soares <[EMAIL PROTECTED]>: > You may use MERGE TABLES: > > http://dev.mysql.com/doc/mysql/en/MERGE.html > > -- > Diana Soares > > On Tue, 2004-05-04 at 10:08, Ken Gieselman wrote: > > Heya folks -- > > > > Trying to come up with a way

Re: count() on multiple similar tables?

2004-05-04 Thread Diana Soares
You may use MERGE TABLES: http://dev.mysql.com/doc/mysql/en/MERGE.html -- Diana Soares On Tue, 2004-05-04 at 10:08, Ken Gieselman wrote: > 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 loope

count() on multiple similar tables?

2004-05-04 Thread Ken Gieselman
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 dat