本文介绍了Mysql子查询顺序的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
mysql 子查询中结果的顺序会影响实际查询的顺序吗?我试过了，但没有得到真正的结果，因为有时看起来如此，有时却不然.
Does the order of the results inside a mysql subquery affect the order of the actual query? I tried it but did not came to a real result cause sometimes it seemed so and sometimes it doesn't.
例如:
SELECT name FROM people WHERE pid IN (SELECT mid FROM member ORDER BY mdate)
在这种情况下，order by"子句会影响结果的顺序吗?
Is the "order by"-clause going to affect the order of the results in this case?
谢谢.
推荐答案
不行，如果你想根据需要更改顺序，最好使用 JOIN
No it cant and if you want to change the order as per your need then better use a JOIN
类似这样的:-
select name
from people p inner join member m on p.pid = m.mid
order by p.name
这篇关于Mysql子查询顺序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！
本站部分内容来源互联网,如果有图片或者内容侵犯您的权益请联系我们删除！