mysql 触发器一个表改变另一个表也改变

mysql 触发器一个表改变另一个也改变

主表：

副表：

删除：

DELIMITER $$

USE `motooling`$$

DELIMITER ;
DROP TRIGGER IF EXISTS `pm_pg_member_delete`;
DELIMITER ;;
CREATE TRIGGER `pm_pg_member_delete` AFTER DELETE ON `user_company` FOR EACH ROW BEGIN
	SELECT dep_id INTO @procId FROM department WHERE dep_code='Production_Dept' AND company_id=old.company_id;
	SELECT dep_id INTO @depIds FROM department WHERE dep_id=old.dep_id AND CONCAT('|', all_upper_ids, '|') REGEXP CONCAT('|', @procId, '|');
	IF old.dep_id IN (@depIds) THEN
		DELETE FROM pm_pg_member WHERE pg_