MySQL Forums
Forum List  »  Merge Storage Engine

Is there an easy way to add a new table to a merge table?
Posted by: Flemming Rodler
Date: June 14, 2005 07:39AM

Is there an easy way to just add a new table to a merge table (should be added as the last one so it will receive data from new inserts).

I know I can propably use Show create table on the merge table to extract the tables that are merges together then add the new one to that list and do an alter table on the merge table. However, I would like to know if there is a more convinient way to do it.

Also is there any easy way to remove the first table in the union list of the merge table?.

Options: ReplyQuote


Subject
Views
Written By
Posted
Is there an easy way to add a new table to a merge table?
7824
June 14, 2005 07:39AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.