ontedi adlı üyeden alıntı

Hocam nette örnekler var.

http://dev.mysql.com/doc/refman/5.7/en/trigger-syntax.html

CREATE TRIGGER `anket` AFTER UPDATE ON `anket_soru`
FOR EACH ROW update anket_soru set durum=0
yaptım islm yaptığımda
#1442 - Can't update table 'anket_soru' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.