MySql 老版本替代leadover的语法
SELECT * FROM
(
SELECT @endtime endlesstime,@endtime:=b.STARTTIME,b.* FROM
(
SELECT @rownum rn,@rownum:=@rownum+1 rn1,a.* FROM
(
SELECT * FROM info_bindinginfo ORDER BY STARTTIME
) a,
(SELECT @rownum:=0) inita
ORDER BY @rownum DESC
) b,
(SELECT @endtime:=STR_TO_DATE("3000-01-01","%Y-%m-%d")) initb
) c
ORDER BY c.rn1