Hi Mihail,
We have nightly process that creates a summary table from multiple tables in the similar
situation.
Best,
Mihail Berman
-----Original Message-----
From: Михаил Монашёв [mailto:michael@stripped]
Sent: Sunday, July 17, 2005 3:41 AM
To: mysql@stripped
Subject: Multitable selection
Hello,
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
Sincerely,
Michael,
http://xoib.com/ http://3d2f.com/
http://qaix.com/ http://ryxi.com/
http://gyxe.com/ http://gyxu.com/
http://xywe.com/ http://xyqe.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1
