What is the difference between join and where in mysql

This article mainly explains "what is the difference between join and where in mysql". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Now let the editor take you to learn "what's 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.menuSecretidrect m.sortaccounidrect. Sortroomidrect. Sortroomname from menu m inner join sort s on m.sort_id=s.sort_id and m.sortroomidrect. Select m.menucalliidreel m.sortroomidgrade.sortaccounidredforce.sortaccounidredit from menu m inner join sort s on m.sort_id=s.sort_id where m.sort_id=2. At this point, I believe you have a deeper understanding of "what's the difference between join and where in mysql?" you might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!