mysql中完成row_number()功能

下列的功能再mysql上会由于row_number功能不存在而报错

select title,content
,ROW_NUMBER() over(partition by title,content order by shows desc) as rk
from yy_push_race_info_v6
where oeid = 1 and is_login = 0

查询了一下发现mysql中其实可以做一些简单的***流式处理***，来处理这种排序打编号的问题，感觉很有意思，记录一下，可以写成

select
if(@temp=dt,@rank:=@rank+1,@rank:=1) rn,
@temp:=dt as dt,
doc_id,
title,
content,
shows
from yy_push_race_info_v6
where oeid = 1 and is_login = 0
order by dt,shows desc

注意temp,rank的用法，就是标准流式处理变量设置方法。