On Thu, 27 Dec 2001 11:19:18 +0800, cbsly <[EMAIL PROTECTED]> wrote:
| In my catalogs, there are many tables with the same structure. Every table is very |large, several | million records and about 1 GB size. It is impossible to merge them into single one. | How can I "select" in all of them at the same time but not "select * from table1 |where ..." then | "select * from table2 where ...", then ... | | Thanks | | cb Use a merge table as an overlay to select from. http://www.mysql.com/doc/M/E/MERGE.html Thanks, Michael -- Michael Brunson 504.473.6643 [EMAIL PROTECTED] ICQ: 83163789 <? Special Projects Programming Manager ?> --- Intercosmos Media Group, Inc. --- www.intercosmos.com www.directnic.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
