Automatic row numeration - MySQL Snipplr Social Repository

Revision: 48633

at July 6, 2011 22:17 by grzebo

Updated Code

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

Revision: 48632

at July 6, 2011 22:16 by grzebo

Initial Code

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

Initial URL

Initial Description

Initial Title

Automatic row numeration

Initial Tags

Initial Language

MySQL