MySQL_插入更新或者插入 ON DUPLICATE KEY UPDATE

 <foreach collection="list" item="item" index="index"
			separator=";">
			INSERT INTO tableName (WHID, MI_CODE, MI_NUMS) 
			 VALUES
			(  #{item.WHID},#{item.MI_CODE},#{item.INVENTORYNUM} )
  			ON DUPLICATE KEY UPDATE MI_NUMS= #{item.INVENTORYNUM}
</foreach> 

根据条件更新或者插入数据

根据条件批量更新或者批量插入数据

官网说明：https://dev.mysql.com/doc/refman/5.5/en/insert-on-duplicate.html