select * from (
select @rownum:=@rownum+1 AS rownum, app_t.* from (
select *
from app_custom
where 1=1
) app_t,(SELECT @rownum:=0) r
) as t where t.rownum between 1 and 10
MySQL增加行号rownum
最新推荐文章于 2024-06-01 13:03:59 发布