Create auto numered column in mysql query

MySQL & MariaDB Other MySQL® Questions
1

Create auto numered column in mysql query

select @rownum:=@rownum+1 nowef,
p.* from item p, (SELECT @rownum:=0) r
order by item_code
desc limit 10;

2

I don’t see a question in this post.