mysql 用 @rownum := @rownum+1 实现 rownum 功能

mysql 用 @rownum := @rownum+1 实现 rownum 功能

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

https://blog.csdn.net/u012102536/article/details/59112054