SELECT
( @rowNO := @rowNo + 1 ) AS rowno,
A.*
FROM
( SELECT * FROM t_user ) a,
( SELECT @rowNO := 0 ) b
转载于:https://www.cnblogs.com/xiaohu1218/p/9192982.html
SELECT
( @rowNO := @rowNo + 1 ) AS rowno,
A.*
FROM
( SELECT * FROM t_user ) a,
( SELECT @rowNO := 0 ) b
转载于:https://www.cnblogs.com/xiaohu1218/p/9192982.html