Skip to content
Advertisement

Creating a trigger that records modifications on table A by inserting values in table B

I’m having problems with the following trigger that records when an insertion with attribute ‘numero’= 4 is made on table A by inserting into table B who made the modification and the number of entries with attribute ‘numero’= 4 in table A. The problem seems to be the select * count but I can’t figure it out. Any help would be greatly appreciated!

Advertisement

Answer

Try to store your count value in a variable first, and use that variable in the INSERT

User contributions licensed under: CC BY-SA
2 People found this is helpful
Advertisement