generate many rows with mysql

Question

In postgres there is a built in function generate_series() which can generate rows with number.

is there a function in mysql does same thing?

Answer 1

try this one:

select @rownum:=@rownum+1 n, t.* from tbl t, (SELECT @rownum:=0) r order by somefield