запрос для row_number в mysql
set @row_number=0; select (@row_number := @row_number +1) as num,id,name from sbs