mysql 合并这两句UPDATE BriefingProfile SET commentposted = commentposted - 1 WHERE commentposted 0 AND briefinguser = OLDcommentator; UPDATE BriefingProfile SET contentcommentgeted = contentcommentgeted

UPDATE BriefingProfile SET commentposted = commentposted - 1, contentcommentgeted = contentcommentgeted - 1 WHERE (commentposted > 0 AND briefinguser = OLD.commentator) OR (contentcommentgeted > 0 AND briefinguser = OLD.publisher);