INSERT into exception_report_total (
waitFillOrders
,waitSendOrders
,changeOrders
,changeTotal
,waitProduceOrders
,wmsStockOrders
,erpStockOrders
,waitReserveOrders
,waitDispatchOrders
,addDispatchOrders
,waitCancel
,sendExceptions
,reserveOrders
,create_time
,carrier_id
,carrier_name
,dc_id
,dc_name
,org_id
,org_name
)
values
<foreach collection="list" item="item" index="index" separator="," >
(
#{item.waitFillOrders}
,#{item.waitSendOrders}
,#{item.changeOrders}
,#{item.changeTotal}
,#{item.waitProduceOrders}
,#{item.wmsStockOrders}
,#{item.erpStockOrders}
,#{item.waitReserveOrders}
,#{item.waitDispatchOrders}
,#{item.addDispatchOrders}
,#{item.waitCancel}
,#{item.sendExceptions}
,#{item.reserveOrders}
,now()
,#{item.carrier_id}
,#{item.carrier_name}
,#{item.dc_id}
,#{item.dc_name}
,#{item.org_id}
,#{item.org_name}
)
</foreach>
on duplicate key update
waitFillOrders = values(waitFillOrders),
waitSendOrders = values(waitSendOrders),
changeOrders = values(changeOrders),
changeTotal = values(changeTotal),
waitProduceOrders = values(waitProduceOrders),
wmsStockOrders = values(wmsStockOrders),
erpStockOrders = values(erpStockOrders),
waitReserveOrders = values(waitReserveOrders),
waitDispatchOrders = values(waitDispatchOrders),
addDispatchOrders = values(addDispatchOrders),
waitCancel = values(waitCancel),
sendExceptions = values(sendExceptions),
reserveOrders = values(reserveOrders)
INSERT into ... on duplicate key update ...
原文：http://www.cnblogs.com/olmlo/p/5144704.html
