advanced code snippet search

Posted By

grzebo on 07/06/11


Tagged

row numeration


Versions (?)

Automatic row numeration

 / Published in: MySQL
 
Expand | Embed | Plain Text 
  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.