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 |
For any types of queries, you can contact us on info[at]namasteui.com.
In the vast digital landscapes of online gaming, legends are born and moments are etched…
In the ever-evolving landscape of entertainment, online gaming stands out as a realm where imagination…
In the fast-paced world of online gaming, the pursuit of excellence is a journey marked…
Understanding the value of investment is an essential component of financial planning. Investing not only…
In today's cutthroat business world, where every cent matters, tracking how well your ad campaigns…
In today's digital age, headshots have become essential for personal branding, particularly for professional platforms…