【mysql】排序分页查询导致数据混乱问题
1.问题说明1.根据创建时间排序,当创建时间大量重复时,分页查询会导致某条数据出现在不同分页中select * from student order by create_time desc limit 10,10;select * from student order by create_time desc limit 20,10;2.问题解决1.如果有id主键,可以再加id排序select * from student order by create_time desc,id asc
复制链接