Not if you are using innoDB tables. For these, you use INSERT and UPDATE triggers.
On Dec 19, 2011, at 11:58 AM, Halász Sándor wrote:
>>>>> 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.
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql