in reply to Re: [OT] SQL "on duplicate key" custom action
in thread [OT] SQL "on duplicate key" custom action
Do you perhaps have a tested version? I can't get this to run.
The trigger functions are all right, it seems, but I don't see how to create the triggers themselves onto the table 'records' so that they react in the desired way. (For one thing, you can't do an 'INSTEAD OF UPDATE' on a table, and when you use a BEFORE INSERT or an AFTER INSERT trigger, this old. and new. business is not going to work.)
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^3: [OT] SQL "on duplicate key" custom action
by Corion (Patriarch) on Oct 21, 2019 at 16:34 UTC |
In Section
Seekers of Perl Wisdom