MySQL触发器：更新con表时自动更新user表

DELIMITER $$ CREATE TRIGGER update_user_table AFTER UPDATE ON con FOR EACH ROW BEGIN IF NEW.user = user AND NEW.status = 2 THEN UPDATE user SET cons = cons + 1, reqs = reqs - 1 WHERE user = NEW.user; END IF; END$$ DELIMITER ;