mysql连接的使用

create database student

create table student(`id` int(4),`name` char(40),`class` char(40),`number` char(40));
create table score(`number` char(40),`chinaese` char(40),`math` char(40),`english` char(40));

insert into student(id,name,class,number) values('1',"张三","一班","201901");
insert into student(id,name,class,number) values('2',"令狐冲","二班","201902");
insert into student(id,name,class,number) values('3',"张三丰","三班","201903");
insert into student(id,name,class,number) values('4',"娜可露露","一班","201904");

insert into score(number,chinaese,math,english) values('201901',"90","87","120");
insert into score(number,chinaese,math,english) values('201902',"82","76","96");
insert into score(number,chinaese,math,english) values('201903',"67","82","110");
insert into score(number,chinaese,math,english) values('201904',"23","66","134");

SELECT  name, class,chinaese, math, english FROM score a INNER JOIN student b ON a.number = b.number;