优化limit SELECT * FROM lyl WHERE ID >=( SELECT id FROM lyl LIMIT 10000,1) LIMIT 5; 转载于:https://www.cnblogs.com/xiatian3452/p/10883611.html