只要下面简单的一句话即可在mysql中检索结果中加入序号。
SELECT @ROW := @ROW + 1 AS ROW, t.*
FROM group_post t, (SELECT @ROW := 0) r
12
SELECT @ROW := @ROW + 1 AS ROW, t.* FROM group_post t, (SELECT @ROW := 0) r
Mysql中@ROW默认从0开始统计。