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 |
Introduction There is an increasing need for full-stack developers because companies want people who can…
Classic Russian literature holds a quiet power that still shapes stories today. Its voice feels…
Digital channels often get most of the attention in modern branding. A business can launch…
If you have been researching digital marketing programs in India, Kraftshala and IIDE both keep…
Email marketing remains one of the highest-performing digital marketing channels because it gives businesses direct…
Pain in muscles and joints can be a problem in everyday life, whether it involves…