Hi Folks,
I guess that mySQLs implementation of REPLACE does a delete instead of
update is due to its history, It never had referential integrity or
triggers until recently, therefore the difference between a
delete/insert and an unpdate would have been non-existant.

It does suggest that if the replace statement doesn't populate all the
fields, that different records will be left using the different syntaxes.

Anyway, back to the question, I only like replace, the others are a
bit obscure for me. Do any other databases support? A quick search on
google suggests that oracle supports MERGE statements which seem to
do a similar thing.

Regards
Ian Newby