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 |
In a world where digital presence is paramount, the question isn't whether you should do…
Over the years, people have experimented with various methods to maintain healthy and beautiful hair.…
Your brand more than developing an attractive and creative logo and infectious motto. It's the…
Introduction Are you someone who has suffered from a personal injury and want to file…
Operating from home has emerged as one of the most popular ways of doing jobs…
If the consequences of our society’s ever-growing debt are what worries you, then it is…