SELECT id, user_id, integral, total_day,
total_integral,
ranking,
create_time,
update_time
FROM
(
SELECT
a.id,
a.user_id,
a.integral,
a.total_day,
a.total_integral,
a.create_time,
a.update_time,
(@rowno :=@rowno + 1) AS ranking
FROM
activity_sign_in a,
(SELECT(@rowno := 0)) b
ORDER BY
a.create_time ASC,
a.id ASC
) c
WHERE
c.user_id = '161'
根据条件查询排名
SELECT id, user_id, integral, total_day,
total_integral,
ranking,
create_time,
update_time
FROM
(
SELECT
a.id,
a.user_id,
a.integral,
a.total_day,
a.total_integral,
a.create_time,
a.update_time,
(@rowno :=@rowno + 1) AS ranking
FROM
activity_sign_in a,
(SELECT(@rowno := 0)) b
ORDER BY
a.create_time ASC,
a.id ASC
) c
查询数据排名