<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