Posted By

grzebo on 07/06/11


Tagged

row numeration


Versions (?)

Automatic row numeration


 / Published in: MySQL
 

  1. SELECT @row := @row + 1, _HERE_TABLE_NAME_ . *
  2. FROM `_HERE_TABLE_NAME_`
  3. JOIN (
  4. SELECT @row := 0
  5. ) AS tmp

Report this snippet  

You need to login to post a comment.