Mysql进阶
1 多表查询
(1) 内连接查询
隐式内连接查询
SELECT product.id,product.productName,productdir.dirName FROM product,productdir WHERE product.dir_id=productdir.id
显示内连接查询
SELECT p1.id,p1.productName,p2.dirName FROM product p1 INNER JOIN productdir p2 ON p1.dir_id=p2.id
SELECT p1.id,p1.productName,p2.dirName FROM product p1 JOIN productdir p2 ON p1.dir_id=p2.id
(2) 外连接查询
SELECT * FROM product LEFT JOIN productdir ON product.dir_id=productdir.id
SELECT * FROM product