MySQL ask where a.id=b.id and join on a.id=b.id the difference in efficiency

MySQL ask where a.id=b.id and join on a.id=b.id the difference in efficiency
Below is Ecshop's commodity table and the brand table query, ask their query efficiency what is the difference?
Another problem is that the efficiency of the LEFT join and join is higher.
Thank you!!

SELECT A. ' goods_id ', A. ' Goods_name ', b.brand_name
From  ' Ecs_goods ' as a

SELECT A. ' goods_id ', A. ' Goods_name ', b.brand_name
From  ' Ecs_goods ' as A, ecs_brand as B
WHERE A. ' brand_id ' = B. ' brand_id '

Mysql

share to: more

------Solution--------------------
Your first type is the left link, because no other filter conditions
The result set will have all the records of the left table (ecs_goods)

Your second type is a comma connection (shorthand for INNER JOIN)
Only records that meet the join criteria appear in the result set

The effect of the two is different, can not do efficiency comparison

