mysql中给查询结果添加序号

示例：

select
@i := @i + 1 as rownum,
user_id as userId,
user_name as userName,
user_sex as userSex
from user,
(SELECT @i := 0) i
WHERE user_sex = 0
 ORDER BY user_id

结果：
其中@后面的字段可以随意替换，但是必须使select后面的和from中保持一致，(SELECT @i := 0) i比需要起别名
整个sql相当于一个表联查，将生成的序号加到查询结果里面