MySQL SQL Collections

插入数据重复，更新其他的列；

 

INSERT INTO TABLE_NAME(CLUOMN,...) VALUES(...) ON DUPLICATE KEY UPDATE SET CLUMON = NEW_VALUE, CLUMON = NEW_VALUE;

 

join UPDATE:

UPDATE HO_User_Soho_Team A LEFT JOIN HO_User_Soho_VIP_Team B ON A.`TeamID` = B.`TeamID` SET A.`TeamState` = '0' WHERE B.`UserID`= "+userID

join DELETE:

DELETE A FROM [SH_ClosingBalance] A LEFT JOIN [SH_StoreHouse] B ON A.StoreHouseID=B.ID
WHERE B.departmentID='1000'