UPDATE triggers with REPLACE statements
- 1 Messages
- Collapse All
- Expand All
- Subscribe
Dec 16
Jim McNeely UPDATE triggers with REPLACE statements
Dec 16, 2011; 16:00
Jim McNeely
UPDATE triggers with REPLACE statements
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
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
Dec 17
Hal?sz S?ndor Re: UPDATE triggers with REPLACE statements
Dec 17, 2011; 22:46
Hal?sz S?ndor
Re: UPDATE triggers with REPLACE statements
Dec 18
Claudio Nanni Re: UPDATE triggers with REPLACE statements
Dec 18, 2011; 20:26
Claudio Nanni
Re: UPDATE triggers with REPLACE statements
Dec 19
Jim McNeely Re: UPDATE triggers with REPLACE statements
Dec 19, 2011; 09:10
Jim McNeely
Re: UPDATE triggers with REPLACE statements
Dec 19
Jim McNeely Re: UPDATE triggers with REPLACE statements
Dec 19, 2011; 11:30
Jim McNeely
Re: UPDATE triggers with REPLACE statements
Dec 19
Claudio Nanni Re: UPDATE triggers with REPLACE statements
Dec 19, 2011; 22:28
Claudio Nanni
Re: UPDATE triggers with REPLACE statements
Dec 19
Jim McNeely Re: UPDATE triggers with REPLACE statements
Dec 19, 2011; 13:55
Jim McNeely
Re: UPDATE triggers with REPLACE statements
Dec 19
Hal?sz S?ndor Re: UPDATE triggers with REPLACE statements
Dec 19, 2011; 14:58
Hal?sz S?ndor
Re: UPDATE triggers with REPLACE statements
Dec 19
Jim McNeely Re: UPDATE triggers with REPLACE statements
Dec 19, 2011; 15:42
Jim McNeely
Re: UPDATE triggers with REPLACE statements
Dec 19
Hal?sz S?ndor Re: UPDATE triggers with REPLACE statements
Dec 19, 2011; 18:51
Hal?sz S?ndor
Re: UPDATE triggers with REPLACE statements
Jan 23
Hal?sz S?ndor Re: UPDATE triggers with REPLACE statements
Jan 23, 2012; 10:44
Hal?sz S?ndor
Re: UPDATE triggers with REPLACE statements
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!