How to show sequential number in MySQL query result

Question

I have some simple query:

SELECT foo, bar FROM table 

i think you now whats the result looks like.

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   | 

How should I do to make it?

thanks in advance

Answer 1

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