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 |
Pain in muscles and joints can be a problem in everyday life, whether it involves…
Most modern businesses spend a lot of time thinking about digital touchpoints. Websites, email campaigns,…
While TikTok and Instagram battle for users’ attention with short vertical videos, Elon Musk’s social…
When you are looking to apply for a mortgage the one thing that most people…
Once you've memorized basic blackjack strategy, it's time to delve deeper into the game. Advanced…
Yoga is no longer just a physical practice. Yoga is popular as a lifestyle practice.…