MySQL Forums
Forum List  »  Merge Storage Engine

Inserting/deleting records into/out of table
Posted by: Nolan Rumble
Date: November 16, 2006 06:21AM

Hi,

I have 2 tables 200607msginfo and 200608msginfo. These 2 tables are joined with a MERGE table 2006msginfo.

When I start importing data into 200608msginfo (via LOAD DATA ...) the table, 200608msginfo gets locked while it is importing the data. Now I want to run a query on 2006msginfo. Does this mean that it'll run a query only once the import is finished (because the 200608msginfo table is locked) or would it only return the results of the 200607msginfo table?

What would happen if I deleted records from a table instead of removing the table from the merged table?

Thanks,
Nolan

Options: ReplyQuote


Subject
Views
Written By
Posted
Inserting/deleting records into/out of table
10697
November 16, 2006 06:21AM


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.