Re: How can I "select" in multi table

2001-12-26 Thread Michael Brunson 

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
 
  ---   Intercosmos Media Group, Inc.  ---
  www.intercosmos.comwww.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

How can I "select" in multi table

2001-12-26 Thread cbsly 

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


===
ÐÂÀËÃâ·Ñµç×ÓÓÊÏä (http://mail.sina.com.cn)
ÐÂÀË·ÖÀàÐÅÏ¢:·ÖÀàÐÅÏ¢ Ë­´¦µß·å? ÄúͶƱ ÎÒËͽ±! (http://classad.sina.com.cn/)
ÐÂÀËÉÁ˸¶ÌÐÅÉÁÁÁµÇ³¡ ´«ÇéÎÞÏÞ 
(http://sms.sina.com.cn/cgi-bin/sms/smspic.cgi?spec=11&type=0)

-
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