2023年8月3日发(作者：)

⼀条sql修改多条数据MyBatis⼀条sql修改多条数据前提紧要 针对同⼀张表的同⼀个字段进⾏不同的值更新操作。sql写法update tb_user setpath = (CASEWHEN id = 1 THEN "path1"WHEN id = 2 THEN "path2"WHEN id = 3 THEN "path3"WHEN id = 4 THEN "path4"END)where id in (1,2,3,4);xml写法 update tb_user set path = ( CASE WHEN id = #{key} THEN #{value} END ) where id in #{key} ⼀条sql修改相同字段不同值，get√

2023年8月3日发(作者：)

⼀条sql修改多条数据MyBatis⼀条sql修改多条数据前提紧要 针对同⼀张表的同⼀个字段进⾏不同的值更新操作。sql写法update tb_user setpath = (CASEWHEN id = 1 THEN "path1"WHEN id = 2 THEN "path2"WHEN id = 3 THEN "path3"WHEN id = 4 THEN "path4"END)where id in (1,2,3,4);xml写法 update tb_user set path = ( CASE WHEN id = #{key} THEN #{value} END ) where id in #{key} ⼀条sql修改相同字段不同值，get√