mysql 增加自定义行号的方法。

select id,@id1 := @id1 +1 as tt,@id2 := @id2 + @id1 as abc from tenant,(select @id1 :=0) as t1,(select @id2:= 100) as t2

结果集

70535950635106304	1	101
70937194633625600	2	103
72406426726694912	3	106
72641808848388096	4	110
73371693350912000	5	115
73410660809048064	6	121
73418020189372416	7	128
77391915938480128	8	136
78427214068056064	9	145