MySQL 5
Making an UPDATE BEFORE trigger.
I want to modify a row in the same table, but not the one that triggered the trigger. Performing an UPDATE query throws an error about not allowing that behavior (updating rows in the same table). Looked it up online and apparently MySQL locks the table, but for some reason doesn't hand that lock to the
(
Read more... )