CREATE TRIGGER update_department_name AFTER UPDATE ON departments
FOR EACH ROW BEGIN
UPDATE performance_records SET department_name = NEW.department_name WHERE department_id = OLD.department_id;
END;
利唐i人事HR社区,发布者:hiHR,转转请注明出处:https://www.ihr360.com/hrnews/20241251659.html