Only if you can change the application you could use INSERT....ON DUPLICATE
KEY UPDATE instead of REPLACE.
Check Peter's post here: http://kae.li/iiigi
Cheers
Claudio
2011/12/17 Jim McNeely <jim@stripped>
> Here is a fun one!
>
> I have a set of tables that get populated and changed a lot from lots of
> REPLACE statements. Now, I need an ON UPDATE trigger, but of course the
> trigger never gets triggered because REPLACES are all deletes and inserts.
>
> The trigger is going to populate another table as a queue for a system to
> do something whenever a particular field changes.
>
> SO, does anyone have some slick idea how to handle this little dilemma? I
> have an idea but I have a feeling there is something better out there.
>
> Thanks!
>
> Jim McNeely
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql
>
>
--
Claudio
