//单字段
update user u
set u.name = (select s.stu_name from student s where s.stu_id = u.stu_id)
//多字段
update user u
set (u.name,u.age )= (select s.stu_name,s.stu_age from student s where s.stu_id = u.stu_id)
//批量更新
update asset_metric_config
set collect_flag = case #{collectFlag}
when 0 then 0
when 1 then 1
end
where id in (${keys})
//也可以
update asset_metric_config
set collect_flag = case id
when 1 then 1
when 2 then 2
end
where id in (1,2)
sql更新
最新推荐文章于 2024-07-08 16:30:46 发布