RE: Adding and Removing tables from MERGE tables dynamically

2006-09-08 Thread Jacob, Raymond A Jr
-Original Message- From: Brent Baisley [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 06, 2006 10:24 To: Jacob, Raymond A Jr; mysql@lists.mysql.com Subject: Re: Adding and Removing tables from MERGE tables dynamically I've got a similar setup, total records across about 8 tables hoovers

Re: Adding and Removing tables from MERGE tables dynamically

2006-09-06 Thread Brent Baisley
I've got a similar setup, total records across about 8 tables hoovers around 200 million. To change a merge table just issue an alter table with a new union. ALTER TABLE mergetable UNION=(table1, table2, table3,...); - Original Message - From: Jacob, Raymond A Jr [EMAIL PROTECTED]