mysql返回记录的ROWNUM(转)
set @rownum = 0;
select (@rownum := @rownum + 1) as rownum, name, scores from user order by scores;
利用一个变量作为计数器,就把这个rownum给模拟出来了。再对这个查询结果进行搜索就可以得到想要的了:
select rownum, name, scores from (selec
转载
2016-11-07 11:39:26 ·
1711 阅读 ·
0 评论