update 一张表 set step_id=case step_id when 10 then 11 when 11 then 18 when 18 then 10 end where step_id in (10,11,18)
update param_record a inner join (select id from param_record where step_id = 11) b on a.id=b.id set a.step_id = 18
update param_record set step_id = 18 where step_id = 11 or update param_record a inner join (select id from param_record where step_id = 11) b on a.id=b.id set a.step_id = 18 ……
提示什么?应该没有问题
56,677
社区成员
56,708
社区内容
加载中
试试用AI创作助手写篇文章吧