How to make auto numbering ( row number ) in mysql query

SUBMITTED BY: Guest

DATE: Aug. 10, 2014, 2:50 a.m.

FORMAT: Text only

SIZE: 423 Bytes

Raw Download

HITS: 3268

Report
  1. How to make auto numbering ( row number ) in mysql query
  3. ##for example
  5. tb_1
  6. ================
  7. name | sell | bonus
  8. aa | 2 | 4
  9. bb | 2 | 1
  10. cc | 2 | 1
  12. ##the query
  14. select @i:=@i+1 as no,name,sell,bonus from tb_1 join (select @i:=0) order by name
  16. ##the result
  18. no | name | sell | bonus
  19. 1 | aa | 2 | 4
  20. 2 | bb | 2 | 1
  21. 3 | cc | 2 | 1
  23. go and try... see you
comments powered by Disqus