传统型
select * from t_card_coupon limit 20000000,10
高效型
select * from t_card_coupon where id in(
select id from (select id from t_card_coupon limit 20000000,10) as t
)
传统型
select * from t_card_coupon limit 20000000,10
高效型
select * from t_card_coupon where id in(
select id from (select id from t_card_coupon limit 20000000,10) as t
)
转载于:https://www.cnblogs.com/zhangjian816/p/7692779.html