List:General Discussion« Previous MessageNext Message »
From:Mikhail Berman Date:July 18 2005 2:07pm
Subject:RE: Multitable selection
View as plain text  
Hi Mihail,

We have nightly process that creates a summary table from multiple tables in the similar


Mihail Berman

-----Original Message-----
From: Михаил Монашёв [mailto:michael@stripped] 
Sent: Sunday, July 17, 2005 3:41 AM
To: mysql@stripped
Subject: Multitable selection


I have 10 tables:
table0: id, description, date
table2: id, description, date
table9: id, description, date

Every table has 1 000 000 rows.

How can I select all rows from this 10 tables ordered by date?
What is faster: UNION or temporary table or something else ?

mysql 4.1


MySQL General Mailing List
For list archives:
To unsubscribe:

Multitable selectionМихаил Монашёв17 Jul
  • Re: Multitable selectionGleb Paharenko19 Jul
    • Re: Multitable selectionMichael Monashev19 Jul
RE: Multitable selectionMikhail Berman18 Jul
  • log fileprathima rao18 Jul
    • Re: log fileBruce Ferrell18 Jul
  • Re: Multitable selectionMichael Monashev19 Jul
Re: Multitable selectionPeter J Milanese19 Jul
  • Re: Multitable selectionMichael Monashev19 Jul
RE: Multitable selectionPMilanese19 Jul