请在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;