MySQL 排名问题
SET @ranking=0;
select * from (select *,@ranking:=@ranking+1 AS `ranking` from computer.computer_user ORDER BY `question_count` DESC) as result where result.id = 6;
SET @ranking=0;
select * from (select *,@ranking:=@ranking+1 AS `ranking` from computer.computer_user ORDER BY `question_count` DESC) as result where result.id = 6;