mysql 实现行号和分页

oracle 行号由系统自带的rownum伪列实现。mysql要实现此功能稍微麻烦一点。如下

SELECT id,name,(@rowNum:=@rowNum+1) as rowNo FROM Area,(Select (@rowNum :=0) ) b

分页

select * from (SELECT id,name,(@rowNum:=@rowNum+1) as rowNo FROM Area,(Select (@rowNum :=0) ) b) res where rowNo>20 and rowNo<30