转自:Mysql查询显示行号,实现类似Oracle数据库的ROWNUM() - 简书
SELECT
( @rownum := @rownum + 1 ) AS rownum,
`animal`.*
FROM
`animal`,
( SELECT @rownum := 0 ) b
ORDER BY
`animal`.create_time DESC
转自:Mysql查询显示行号,实现类似Oracle数据库的ROWNUM() - 简书
SELECT
( @rownum := @rownum + 1 ) AS rownum,
`animal`.*
FROM
`animal`,
( SELECT @rownum := 0 ) b
ORDER BY
`animal`.create_time DESC