For mysql help, may I ask wherea. id = B. id and joinona. id = B. the difference between the efficiency of IDS is as follows: query the Product Table and brand table of ecshop & nbsp;. what is the difference between their query efficiency? & Nbsp; another problem is & nbsp; left & nbsp; for mysql help, the difference in efficiency between where a. id = B. id and join on a. id = B. id
The following is a query of the ecshop product table and brand table. what is the difference in query efficiency?
Another problem is the efficiency of left join and join.
Thank you !!
SELECT a.`goods_id` , a.`goods_name` , b.brand_name
FROM `ecs_goods` AS a
LEFT JOIN ecs_brand AS b ON a.`brand_id` = b.`brand_id`
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`
Share with mysql: More
