发表于： 2017-10-27 23:26:22
1 709
今天完成的事情：
对了一遍接口文档，准备方案评审的，然后发现方案设计还需要再改一下，不过问题也不大
关于分页查询有点不明白sql怎么写就查了一波
第一种
select distinct uid from 收藏表 order by uid desc limit 0, 10;select distinct uid from 收藏表 order by uid desc limit 11, 10;第二种（$last_min_uid表示上一次读到的最后一个uid）
select distinct uid from 收藏表 order by uid desc limit 10;select distinct uid from 收藏表 where uid < $last_min_uid order by uid desc limit 10;第三种
select uid from 收藏表 group by uid order by uid desc limit 10;select uid from 收藏表 group by uid having uid < $last_min_uid order by uid desc limit 10;emmmmm。。。用到的时候再试试吧
看了老大写的新文章，还是有些感触，成功之路真的布满荆棘
明天计划的事情：
Excel建表，复习任务中的知识
返回列表
评论