mysql批量更新

方式一


update t_studetn set
name = #{stud.name},
age = #{stud.age},
class = #{stud.sex},
where id = #{stud.id}


方式二

UPDATE t_student
SET name = CASE id

WHEN #{i.id} THEN #{i.name}

END,
age = CASE id

WHEN #{i.id} THEN #{i.age}

END
WHERE id IN

id=#{i.id}