INSERT INTO test_table (BUSINESS_DATE,CITY_CODE,S4_COUNT,S4_MONEY)
SELECT "2017-08-15","4402","222","444" FROM DUAL
ON DUPLICATE KEY UPDATE S4_COUNT = VALUES(S4_COUNT),S4_MONEY = VALUES(S4_MONEY);
BUSINESS_DATE 和CITY_CODE 主键
MySQL 独有的方法
主键(BUSINESS_DATE ,CITY_CODE )放在最前面