mysql批量更新方法

<update id="xxx"  parameterType="java.util.List">    
        update table set isDelete=0  
        where id in (   
    <foreach collection="list" item="item" index="index" open="" close="" separator=",">  
        #{item.id}  
    </foreach>        
        )       
  </update> 

第二种：

UPDATE USER_XXX AS um,
 (
	SELECT
		T2.MSG_ID
	FROM
		message_xxx AS T2
	INNER JOIN USER_XXX AS T1 ON T1.ID = T2.ID
	WHERE
		T1.xxx = ''
) AS ms
SET xxx = xxx
WHERE
	um.ID = ms.ID

第三种：

UPDATE table1 
SET (column_name, column_name) = (
	SELECT
		(column_name, column_name)
	FROM
		table2
	WHERE
		column_name = column_name
)
WHERE
	column_name = value