MySQL Forums
Forum List  »  Merge Storage Engine

Advanced Search
New Topic

Re: Is there an easy way to add a new table to a merge table?
Posted by: Ingo Strüwing
Date: June 15, 2005 04:21AM

The simplest method should be to just edit the .MRG file with a text tool like an editor or a script.

I know of no simple way to do it with SQL. You will always have to specify the full new table list with ALTER TABLE tbl_name UNION = ( tbl_list ).

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Is there an easy way to add a new table to a merge table?
7839
Flemming Rodler
June 14, 2005 07:39AM
Re: Is there an easy way to add a new table to a merge table?
5258
Ingo Strüwing
June 15, 2005 04:21AM
Re: Is there an easy way to add a new table to a merge table?
5078
Vinayak Javaly
May 23, 2006 07:32AM
Re: Is there an easy way to add a new table to a merge table?
4769
Vinayak Javaly
May 23, 2006 07:39AM
Re: Is there an easy way to add a new table to a merge table?
4880
Ingo Strüwing
May 24, 2006 03:47AM


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.