Add the serial number field to the Mysql query result.

Some people asked me how to add a serial number field in the absence of a continuous id in mysql, so that the queried data contains numbers 1, 2, and 3. Let's look at the method below.

In the following simple sentence, you can add the serial number to the mysql search result.

SELECT @ ROW: = @ ROW + 1 as row, t. * FROM group_post t, (SELECT @ ROW: = 0) r
 
@ ROW in Mysql starts from 0 by default.

The red box shows how many records are generated and how many serial numbers are generated,