select (@i:=@i+1) as i, **** from **,(select @i:=0) as it
WHERE
FROM_UNIXTIME( ***, '%Y_%m' ) = '2016_12'
set @rownum=0;
SELECT (@rownum := @rownum+1) AS rowno,
**** from **
WHERE
FROM_UNIXTIME( ***, '%Y_%m' ) = '2016_12' 时间函数
select (@i:=@i+1) as i, **** from **,(select @i:=0) as it
WHERE
FROM_UNIXTIME( ***, '%Y_%m' ) = '2016_12'
set @rownum=0;
SELECT (@rownum := @rownum+1) AS rowno,
**** from **
WHERE
FROM_UNIXTIME( ***, '%Y_%m' ) = '2016_12' 时间函数