tag:blogger.com,1999:blog-12459003.post5535425919050289305..comments2023-08-03T09:19:28.438-04:00Comments on So What Co-operative: MySQL Pseudo-partitioningJeff Hunterhttp://www.blogger.com/profile/15701602600662849251noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-12459003.post-44441310990453764802007-04-27T19:38:00.000-04:002007-04-27T19:38:00.000-04:00Whoa! No need to go through all that trouble. Ch...Whoa! No need to go through all that trouble. Change all the historical tables to MyISAM and use a MERGE table:<BR/><BR/>CREATE TABLE xyz_all (<BR/>`id` bigint(10) NOT NULL default '0',<BR/>`report_dt` date default NULL,<BR/>`acct_id` varchar(8) default NULL,<BR/>`some_text` varchar(222) default NULL,<BR/>PRIMARY KEY (`id`)<BR/>) ENGINE=MERGE UNION=(xyz_2007_01,xyz_2007_02,xyz_2007_03,Sheeri K. Cabralhttps://www.blogger.com/profile/13990877688502800403noreply@blogger.comtag:blogger.com,1999:blog-12459003.post-589721738588482202007-04-27T07:31:00.000-04:002007-04-27T07:31:00.000-04:00It does, but how do you put that into a views?It does, but how do you put that into a views?Jeff Hunterhttps://www.blogger.com/profile/15701602600662849251noreply@blogger.comtag:blogger.com,1999:blog-12459003.post-1778058901642515412007-04-27T05:11:00.000-04:002007-04-27T05:11:00.000-04:00select id, report_dt, acc_id from xyz_2007_01 wh...select id, report_dt, acc_id from xyz_2007_01 where report_dt ='2007-02-17' and account_id = 'X0000741'<BR/> -> union<BR/>select id, report_dt, acc_id from xyz_2007_02 where report_dt ='2007-02-17' and account_id = 'X0000741'<BR/> -> union<BR/> -> select id, report_dt, acc_id from xyz_2007_03 where report_dt ='2007-02-17' and account_id = 'X0000741';<BR/><BR/>would that Anonymousnoreply@blogger.com