例子 - limit 10000, 20

• idx_firstname
• idx_firstname_middlename
• idx_firstname_middlename_lastname
• idx_age
• idx_aliasname_unique

  select firstname, age FROM test_isolation.user where age > 20 and age <50  limit 10000, 20

  
  

例子 - limit id

• idx_firstname
• idx_firstname_middlename
• idx_firstname_middlename_lastname
• idx_age
• idx_aliasname_unique

  select a.firstname, a.age FROM test_isolation.user a,
  (select id FROM test_isolation.user where age > 20 and age <50  limit 10000, 20) b
  where a.id = b.id