You can add a sequential number as a custom row number of a row using SET clause and increment at next row.
Suppose users table has columns name and age.
When you want to show the result you want to add extra column serial_no.
SET @serial_number = 0; SELECT (@serial_number:=@serial_number + 1) AS serial, name, age FROM users LIMIT 0,50;
| Serial no | Name | Age |
| 1 | John | 25 |
| 2 | Jane | 24 |
| 3 | Tim | 34 |
Modern web applications rarely live alone. A customer portal, an internal order-management console, or a…
An invoice lands in the accounts inbox for equipment delivered three weeks ago. The supplier…
A Google Ads management campaign can look healthy in the dashboard and still waste money…
A potential customer arrives on your website after searching for a service you provide. They…
In the business world, there’s no such thing as a new idea. The best we…
Both of these work. Both are difficult. And anyone telling you one is obviously better…