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
利用Mysql在Insert Into的时候检查数据存在就更新
最新推荐文章于 2023-08-29 17:51:06 发布