MySQL入门笔记 —— 023 内连接查询

1、练习准备

create table boy (
    hid char(1),
     bname varchar(20)
 )engine myisam charset utf8;


 insert into boy (bname,hid)
     values
     ('屌丝','A'),
     ('杨过','B'),
     ('陈冠希','C');


 create table girl (
    hid char(1),
     gname varchar(20)
     )engine myisam charset utf8;


 insert into girl(gname,hid)
     values
     ('小龙女','B'),
     ('张柏芝','C'),
     ('死宅女','D');

2、语句识记

3、内连接查询