PHP之MySQL学习笔记三
数据库的多表查询
1. 将两个表的数据连接起来
select username ,gname from shop_user inner join shop_goods on shop_user.gid = shop_goods.gid;
//gid 对应商品的ID 将username 购买的商品与商品名称对应起来。内联查询
select shop_user.usename from shop_user left(right) join shop_goods on shop_user.gid = shop_goods.gid;
//左右连接
select *from shop_user where gid in(select gid from shop_goods);
//将谁买的商品的人查询出来,效率慢