What are the differences between join and where in mysql

This article mainly shows you "what are the differences between join and where in mysql". The content is simple and clear. I hope it can help you solve your doubts. Let me lead you to study and learn "what is the difference between join and where in mysql".

1. Join joins the data that meets the on criteria into a new table.

2. Where first joins two tables to a new table through Cartesian product, then judges the conditions, and rows the qualified data into a table.

Example

Select m.menuSecretidrect m.sortaccounidrect. Sortroomidrect. Sortroomname from menu m join sort s on m.sort_id=s.sort_id and m.sortroomidrect. Select m.menucalliidreel m.sortroomidgrade.sortaccounidredforce.sortaccounidredit from menu m join sort s on m.sort_id=s.sort_id where m.sort_id=2. Select m.mysql from menu m inner join sort s on m.sort_id=s.sort_id where m.sortroomidgrade.sortSecretidgrade.sortcalliname join m.sortcalliidstation2select m.menucalliidgrade.sortcalliidgrade.sortcalliidres.sortaccounidres.sortprincipidreachm.sortcalliidredform.sortcalliid.sortclassiidwriting.sortcalliid.sortclassiidwriting.sortclassiidreaching.sortSecretidwriting.what is the difference between where and join in mysql? thank you for your reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!