mysql 默认排序的问题
PHPz
PHPz 2017-04-17 13:35:10
0
1
267

SELECT goods_id
FROM (who_edtion_goods)
WHERE edtion_id = '118'
AND cat_id = '315'
ORDER BY sort desc
LIMIT 0,12

SELECT goods_id
FROM (who_edtion_goods)
WHERE edtion_id = '118'
AND cat_id = '315'
ORDER BY sort desc
LIMIT 30,30

数据库中所有sort都为0,奇怪的事是,查询出来的结果集居然有重复部分。goods_id时没有重复的

PHPz
PHPz

学习是最好的投资!

reply all(1)
伊谢尔伦

这种情况排序规则不好确定,但是至少不会随机排序,即两次查询的排序顺序是一样的,所以你出现的这种情况可以进行多次尝试看看具体重复在什么地方,比如你讲第二条sql改成limit 13 20看看还有没有重复

Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!