#连接查询
/*多表查询:需要用到的字段来自于多个表
笛卡尔乘积现象:表1有M行,表2有n行,结果=m*n行
发生原因:没有有效的连接条件
解决方法:
*/
#素材:
CREATE TABLE women(
id INT,
NAME VARCHAR(12),
sex VARCHAR(1),
boyfriend_id INT
);
CREATE TABLE man(
id INT,
NAME VARCHAR(3),
userCP VARCHAR(3)
);
SELECT* FROM women;
SELECT * FROM man;
INSERT INTO women(id,NAME,sex,boyfriend_id)VALUES(1,'柳岩','女');
#INSERT INTO women(id,NAME,sex,boyfriend_id)VALUES();
#INSERT INTO women(id,NAME,sex)VALUES();
INSERT INTO women(id,NAME,sex)VALUES(2,'苍老师','女');
INSERT INTO women(id,NAME,sex,boyfriend_id)VALUES(3,'angelababy','女',3);
INSERT INTO women(id,NAME,sex,boyfriend_id)VALUES(4,'热巴','女',2);
INSERT INTO women(id,NAME,sex)VALUES(5,'周冬雨','女');
INSERT INTO wo
sql:连接查询(多表查询)
最新推荐文章于 2022-10-23 13:18:07 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)