如何在MySQL查询结果中显示序号 [英] How to show sequential number in MySQL query result

问题描述

我有一些简单的查询:

SELECT foo, bar FROM table

我认为您现在的结果是什么样的.

i think you now whats the result looks like.

我要做的是根据查询结果中显示的数据量显示一些序号.它就像AUTO_INCREMENT(这并不意味着我想显示ID). 我想要的结果是这样的:

What I want to do is to show some sequential number based on how many data appear from query result. its just like AUTO_INCREMENT(its not mean i want to show ID). The result what I want is like:

|No|   foo   |    bar   |
-------------------------
|1 |   bla   |    123   |
|2 |   boo   |    abc   |
|3 |   wow   |    xxx   |

我应该怎么做?

预先感谢

推荐答案

select @rownum:=@rownum+1 No, foo, bar from table, (SELECT @rownum:=0) r;

这篇关于如何在MySQL查询结果中显示序号的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！