连表查询的四种方式:合并,内连接,外连接,交叉连接。
本文用表:
– 表1
CREATE TABLE clh_t_boys
(
id INT PRIMARY KEY auto_increment,
name
VARCHAR(20),
class INT,
age INT,
hometown VARCHAR(20)
)
ENGINE=INNODB DEFAULT CHARSET=utf8;
– 表2
CREATE TABLE clh_t_girls
(id INT PRIMARY KEY auto_increment,
name
VARCHAR(20),
class INT)
ENGINE=INNODB DEFAULT CHARSET=utf8;
插入数据:
INSERT INTO clh_t_boys(name
,class,age,hometown)
VALUE(‘Dean’,’1’,’21’,’上海’);
INSERT INTO clh_t_boys(name
,class,age,hometown)
VALUE(‘Sam’,’1’,’22’,’北京’);
INSERT INTO clh_t_boys(name
,class,age,hometown)
VALUE(‘Dannis’,’2’,’20’,’上海’);
INSERT INTO clh_t_boys(name
,class,age,hometown)
VALUE(‘Van’,’4’,’21’,’北京’);
INSERT INTO clh_t_boys(