SELECT
( @rowNO := @rowNo + 1 ) AS rowno, A.*FROM ( SELECT * FROM t_user ) a, ( SELECT @rowNO := 0 ) b本文共 157 字，大约阅读时间需要 1 分钟。
SELECT
( @rowNO := @rowNo + 1 ) AS rowno, A.*FROM ( SELECT * FROM t_user ) a, ( SELECT @rowNO := 0 ) b转载于:https://www.cnblogs.com/xiaohu1218/p/9192984.html