MySQL练习之编写sql语句

请在MySQL中编写SQL，创建学校表schools和学生表students，设置关联关系，添加若干记录，并查询每个学生的姓名及他们对应的学校名称

解析过程:
1.先创建“一”方学校表

 create table schools(   
 id int primary key auto_increment,  
 school_name  varchar(20) not null,  
 address varchar(30),    
 history  text  ); 

2.再创建"多"方学生表

create table students(     
id int primary key auto_increment,     
name  varchar(20) not null,     
age   int,      
sex   varchar(10) not null,     
school_id int,    
constraint fk_students foreign key(school_id) references schools(id)       
on delete cascade on update cascade  );

3.查询

select  students.name,schools.school_name       from students inner join schools on students.school_id=schools.id;