Computer and Internet » Server » MySQL » Triggers
ID #1007
Can't update table in stored function/trigger because it is already used by statement which invoked this stored function/trigger
when you insert a record mysql is doing some lock stuff. you can't
insert/update/delete rows of the same table where you insert.. because
then the trigger would called again and again.. ending up in a recursion
Tags: -
Related entries:
- Right Character Encoding with CakePHP and Dojo Toolkit
- Javascript Date Function
- How can I check to see whether a trigger exists and if it exists then delete it ?
- How can I have multiple triggers on the same table and event?
- Can I check if a variable is defined in javascript?
Last update: 2006-10-20 19:04
Author: Christian Trummer
Revision: 1.0
You cannot comment on this entry