Snippet Name: Select row number in MySQL Description: Simple and straightforward: select the row number in mySQL. Comment: (none) Language: MYSQL Highlight Mode: MYSQL Last Modified: March 01st, 2009
Description: Simple and straightforward: select the row number in mySQL.
SELECT @row := @row + 1 AS row, t.* FROM some_table t, (SELECT @row := 0) r
