MySQL触发器：更新con表时同步更新user表

DELIMITER $$ CREATE TRIGGER update_user_reqs AFTER UPDATE ON con FOR EACH ROW BEGIN IF NEW.user = OLD.user AND NEW.status = 2 THEN UPDATE user SET reqs = reqs - 1 WHERE user = NEW.user AND OLD.req > 0; END IF; END$$ DELIMITER ;