get row no through mysql query

Question

hello sir How to get the row no through mysql query for each row? (i want to display sno) Please help me sir

Answer 1

I believe you are looking to see if you can get the row number for each row through MySQL query right? here's one:

SELECT @rownum:=@rownum+1 AS ‘rownum’, t.* FROM `table` AS t, (SELECT @rownum:=0) `r`