MySQL语句合并 UPDATE CommunicationContact SET messages = messages + 1 WHERE username = NEWreceiver AND contact = NEWsender; UPDATE CommunicationProfile SET contactmessages = contactmessages + 1 WHERE us

UPDATE CommunicationContact cc JOIN CommunicationProfile cp ON cc.username = cp.username SET cc.messages = cc.messages + 1, cp.contactmessages = cp.contactmessages + 1 WHERE cc.contact = NEW.sender AND cc.username = NEW.receiver;