利用Mysql在Insert Into的时候检查数据存在就更新

INSERT INTO wms_to_ccs ( warehouseCode, Lpn, Area2 ) VALUES ( 'XQC01', 'LPN005', 1 ), ( 'XQC01', 'LPN038', 1 ), ( 'XQC01', 'LPN004', 1 ), ( 'XQC01', 'LPN003', 1 ), ( 'XQC01', 'LPN036', 1 ), ( 'XQC01', 'LPN014', 1 ), ( 'XQC01', 'LPN035', 1 ), ( 'XQC01', 'LPN002', 1 ), ( 'XQC01', 'LPN007', 1 ), ( 'XQC01', 'LPN006', 1 ), ( 'XQC01', 'LPN030', 1 ), ( 'XQC01', 'LPN011', 1 ), ( 'XQC01', 'LPN031', 1 ) ON DUPLICATE KEY UPDATE Area2 = 2