DELIMITER $$DROP TRIGGER /*!50114 IF EXISTS */ `saas`.`del_tree`$$create trigger `saas`.`del_tree` AFTER DELETE on `saas`.`tree`
for each row BEGINdelete from tree where tid= old.id;
END
$$DELIMITER ;我现在删除一条数据,他不让我删除
Error Code : 1442
Can't update table 'tree' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.
(0 ms taken)不知道是什么原因,刚学mysql不久,请人回答下,谢谢
for each row BEGINdelete from tree where tid= old.id;
END
$$DELIMITER ;我现在删除一条数据,他不让我删除
Error Code : 1442
Can't update table 'tree' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.
(0 ms taken)不知道是什么原因,刚学mysql不久,请人回答下,谢谢
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货