create table `table` (id)
insert into `table` (`id`) values (1)
insert into `table` (`id`) values (2)
insert into `table` (`id`) values (3)
insert into `table` (`id`) values (4)
select * from `table` order by id desc limit 0,1
insert into `table` (`id`) values (5)
insert into `table` (`id`) values (6)
select * from `table` order by id desc limit 1,1
# 预期结果: 4,3
# 实际结果: 4,5
解决方案
记录当前拉取位置,下一次分页查询将其作为条件加入
解决案例
create table `table` (id,gmt_create) # gmt_create 为插入时间,自动生成
insert into `table` (`id`) values (1)
insert into `table` (`id`) values (2)
insert into `table` (`id`) values (3)
insert into `table` (`id`) values (4)
select * from `table` order by id desc limit 0,1
insert into `table` (`id`) values (5)
insert into `table` (`id`) values (6)
select * from `table` order by id where gmt_create<`atime` desc,gmt_create limit 1,1
# 预期结果: 4,3
# 实际结果: 2,1
新增操作导致数据重复产生机理分页查询过程当中,有数据新增,导致查询数据重复案例create table `table` (id)insert into `table` (`id`) values (1)insert into `table` (`id`) values (2)insert into `table` (`id`) values (3)insert into `table` (`id`) values (4)select * from `table` order by