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