表A
ID LEVEL next
----------------------------------
1 1
2 2
5 3
4 4
写一个sql语句
根据level字段更新next字段,例如:level 1 的next字段是 level 2 的ID
结果是:
ID LEVEL next
----------------------------------
1 1 2
2 2 5
5 3 4
4 4
SELECT * from test_a ORDER BY level
答案:(只支持mysql,oracle下测试失败,记得oracle下update不能关联或者子查询)
update test_a a, (select id,level from test_a order by level) x set next = x.id where a.level<x.level