-- 方法一
SET @row_number = 0;
SELECT
(@row_number:=@row_number + 1) AS num,t.*
FROM
tb_sql_config t
LIMIT 100; -- 返回多少行
-- 方法二
SELECT
(@row_number:=@row_number + 1) AS num, s.*
FROM
tb_sql_config s,(SELECT @row_number:=0) AS t
LIMIT 70;