Jim Starkey wrote:

> I don't understand this at all. REPLACE has been used in many database
> systems for years, and, unless I've missed something, now part of the
> standard as MERGE. The Oracle semantics are sane and sensible. The
> MySQL semantics are not.

MERGE is a complex statement that can be used as REPLACE, but with very
unfriendly syntax.

Main scope of MERGE is to get data from one table and insert/update in
another.

It do a outer join of one table with another, if the result of one side
exist, it's updated. Otherwise it's inserted.


Adriano