也许您可以创建一个索引表，该表提供与目标表中的键相关的顺序键。然后，您可以将此索引表连接到目标表，并使用where子句更有效地获取所需的行。
#create table to store sequencesCREATE TABLE seq ( seq_no int not null auto_increment, id int not null, primary key(seq_no), unique(id));#create the sequenceTRUNCATE seq;INSERT INTO seq (id) SELECt id FROM mytable ORDER BY id;#now get 1000 rows from offset 1000000SELECt mytable.* FROM mytable INNER JOIN seq USING(id)WHERe seq.seq_no BETWEEN 1000000 AND 1000999;
