update employee_test b
JOIN
(select empid,page,index_num,page * index_num as tindex from employee_test where (page - 1) * 600 + index_num <n order by page desc)a
on a.empid = b.empid
set b.page =( case b.page when b.index_num + 1 > 600 then b. page + 1 else b.page end ),
b.index_num=(case b.index_num when b. index_num + 1 > 600 then b.index_num + 1 - b.page * 600 else b.index_num + 1 end)
一条sql批量更新数据,update结合select 和 case when then
最新推荐文章于 2021-12-19 20:51:00 发布