MySQL Forums
Forum List  »  Oracle

Does MySQL 5.0 support the SQL Merge statement
Posted by: Theron Kousek
Date: March 03, 2006 01:33PM

Hi All:

I like the SQL Merge Into... Using()... When Matched UPDATE SET.. When Not Matched INSERT ...". statement quite a bit and find it to be extremely useful in Oracle and DB2.

I don't believe MySql 5.0 supports this statement. When trying it thru TOAD or some other front end tool for mysql, the engine complains.

I did not see anything in the documentation regarding this.

Can someone verify this to be the case that mysql 5.0 does not support the Merge?

thanks Kindly!!!

Options: ReplyQuote


Subject
Views
Written By
Posted
Does MySQL 5.0 support the SQL Merge statement
25935
March 03, 2006 01:33PM


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.