合并这两句 mysql 更新语句 UPDATE p SET followed = followed + 1 WHERE user = NEWuser ; UPDATE p SET befollowed = befollowed + 1 WHERE user = NEWfollowing;
UPDATE p SET
followed = followed + 1,
befollowed = befollowed + 1
WHERE user IN (NEW.user, NEW.following);
原文地址: https://www.cveoy.top/t/topic/bCHr 著作权归作者所有。请勿转载和采集!