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
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
转载于:https://www.cnblogs.com/qianjinyan/p/11349053.html