mysql按排序查询数据,返回数据行数
select a.*,
(@rownum := @rownum + 1) rownum
from (select u.user_id,
u.user_name
from t_user u
where and u.user_id = 1
order by u.user_id asc) a,
(select (@rowNum := 0)) b