What are the differences between in and exists in MySQL?

Alibaba cloud Q & A 2022-02-13 05:13:07 阅读数:183

differences exists mysql

Please elaborate .

Take the answer 1:

mysql Medium in The statement is to make the appearance and the inner table as hash Connect , and exists A statement is an external statement loop loop , Every time loop Loop and query the inner table .

copyright:author[Alibaba cloud Q & A],Please bring the original link to reprint, thank you. https://en.javamana.com/2022/02/202202130513059584.html