MySql之rownum实现

Mysql rownum 实现（极度推荐）

SELECT @rownum:=@rownum+1 AS rownum, tn.*
FROM (SELECT @rownum:=0) r, table_name tn;

 

SELECT @rownum:=@rownum+1 rownum, CollectSn From
(SELECT @rownum:=0,tn.* FROM table_name tn WHERE collectsn!='' ORDER BY collectsn limit 10) t