思路:
检索每一个id值,如果为奇数则设为i+1,如果是偶数则设为i-1,注意末位是奇是偶,重新输出即可。
代码:
select if(id<(select count(*) from seat),if(id%2=0,id-1,id+1),if(id%2=0,id-1,id)) as id,student
from seat
order by id;
思路:
检索每一个id值,如果为奇数则设为i+1,如果是偶数则设为i-1,注意末位是奇是偶,重新输出即可。
代码:
select if(id<(select count(*) from seat),if(id%2=0,id-1,id+1),if(id%2=0,id-1,id)) as id,student
from seat
order by id;