INSERT into ... on duplicate key update ...

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)