Re: UPDATE triggers with REPLACE statements

[(Hal]

>>>> 2011/12/19 11:30 -0800, Jim McNeely >>>>
In the MySQL documentation, we find this tantalizing statement:

"It is possible that in the case of a duplicate-key error, a storage engine may perform
the REPLACE as an update rather than a delete plus insert, but the semantics are the
same. There are no user-visible effects other than a possible difference in how the
storage engine increments Handler_xxx status variables." 
<<<<<<<<
Well, try it--but beware of these statements: "the semantics are the same. There are no
user-visible effects other than a possible difference in how the storage engine
increments Handler_xxx status variables."

If accurate, the triggers are those of DELETE & INSERT, not UPDATE.