mysql rownum 的实现方法
SELECT @rownum := @rownum+1 rownum, id
from (
SELECT @rownum := 0, id
FROM t_student
WHERE status = 1
ORDER BY id asc
) as t
mysql rownum 的实现方法
SELECT @rownum := @rownum+1 rownum, id
from (
SELECT @rownum := 0, id
FROM t_student
WHERE status = 1
ORDER BY id asc
) as t