Hi fellow php-programmers!
For one of my projects I want to count the nr. of entries in my tables. I know how to do this for 1 table:
SELECT count(*) FROM foo1;
But now I want to do this for 3(or more) tables together. These tables have the exact same layout. Is merge/union of these table and then count(*) from the new (temporary) table a correct way of solving this?
Hope somebody outthere can help me. Any input is very much appreciated!
Tom
For one of my projects I want to count the nr. of entries in my tables. I know how to do this for 1 table:
SELECT count(*) FROM foo1;
But now I want to do this for 3(or more) tables together. These tables have the exact same layout. Is merge/union of these table and then count(*) from the new (temporary) table a correct way of solving this?
Hope somebody outthere can help me. Any input is very much appreciated!
Tom