SQL & amp; MySQL Query add field as row number _ MySQL

SQLamp; amp; MySQL Query adds a field as the row number bitsCN.com

Add a field for SQL & MySQL Query as a row number

SQL:

Select row_number () over (order by col desc), * from table;

The "row_number" function must have an OVER clause using order by, which is sorted BY the field col.

Automatic column values

MySQL:

SET @ r = 0;

SELECT @ r: = IFNULL (@ r, 0) + 1 AS rownum, table. * FROM table order by col DESC;

Different from SQL, add fields to the Loop. if you want to query all rows, you must add the table name table. *.

Field is not required, col1, col2...

BitsCN.com