I am trying to get a column that shows numbers for every row kind of like this:
- row_nr id t1 t2 t3
1 1 a b c
2 3 d e f
3 4 g h i
4 6 j k l
5 7 m n o
set @row_n = 0; SELECT @row_n := @row_n + 1 as row_nr,ID,Name,Surname,PID,Age,Gender,Address,Email,Phone,Country,Other_country,Residence,Motivation,Skills,ICT_skills,Interactions,Specialization,GDPR
FROM Specialists
ORDER BY ID;
Can someone please help?
Thank you