select c.* from(
SELECT a.*,b.TABLE_ROWS,floor((a.`行号`-1)/${tiao})+1 as 当前页,round(b.TABLE_ROWS/(${tiao})) as 页数 FROM
(
SELECT (@i:=@i+1)"行号", t.* FROM `stock` t,(select @i:=0)j)a,
information_schema.`TABLES` b
WHERE b.TABLE_NAME = 'stock'and TABLE_SCHEMA='production')c
where c.当前页=${page}我刚好有个实例。你参考一下也是mysql的。
更新回答：
1min目标场景问卷
立即参与
