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 today’s fast-paced and highly competitive marketing environment, even the most creative campaign is only…
We are NYC moving firm. Are you planning a flat move? Maybe a distance or…
Mobile devices, unlike desktops and laptops, can not be handled by dozens or hundreds of…
Augmented Reality- An immersive experience for the learners! Learning and education aren’t the same as…
On special days like birthdays and weddings, we all like to celebrate our loved ones…
A web application is different from a regular mobile or desktop application as it runs…