Ask a Question
Advertise on boostr.in
Organizational Research By
Surprising Reserch Topic
mysql triggers cannot update rows in same table the trigger is assigned to sugg
mysql triggers cannot update rows in same table the trigger is assigned to sugg ¬†using -'mysql,database,database-design,stored-procedures,triggers'
MySQL doesn't currently support updating rows in the same table the trigger is assigned to since the call could become recursive. Does anyone have suggestions on a good workaround/alternative? Right now my plan is to call a stored procedure that performs the logic I really wanted in a trigger, but I'd love to hear how others have gotten around this limitation.
Edit: A little more background as requested. I have a table that stores product attribute assignments. When a new parent product record is inserted, I'd like the trigger to perform a corresponding insert in the same table for each child record. This denormalization is necessary for performance. MySQL doesn't support this and throws:
Can't update table 'mytable' in stored function/trigger because it is already used by statement which invoked this stored function/trigger. ¬†A long discussion on the issue on the MySQL forums basically lead to: Use a stored proc, which is what I went with for now.
Thanks in advance!
Oct 7, 2015
to add a comment.
Related Hot Questions
Government Jobs Opening