mysql 用 @rownum := @rownum+1 实现 rownum 功能
SELECT @rownum := @rownum+1 AS rownum,
table1.*
FROM (SELECT @rownum:=0) r ,
table1;
mysql 用 @rownum := @rownum+1 实现 rownum 功能
SELECT @rownum := @rownum+1 AS rownum,
table1.*
FROM (SELECT @rownum:=0) r ,
table1;