Mysql子查询顺序 [英] Mysql subquery order

问题描述

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子查询顺序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！