MySQL, Query, Optimization, Web Performance, Database.
where a.id=b.id is different, on the table is connected, where is the data comparison Note: The premise must be that the result is NULL (ie, the conditional restriction is not NULL data lines, semantically internal connections) Optimization principle: Streamlined queries, join elimination,