mysql基本语法练习题

**

多表查询与嵌套查询

😗*

1.单表查询
2.标记文本连接查询
3嵌套查询
4.集合查询
5.基于派生表的查询
6.select语句的一般形式

连接查询的要素:

Mysql的query脚本做查询的数据内容

drop database if exists stu;

create  database  stu default character set utf8;

use  stu;

create  table  student(
  sno varchar(6) primary key,
  sname varchar(10) not null ,
  sage tinyint,
  ssex varchar(2) default '男',
  sdept varchar(10)
)engine=innodb;



create  table  course(
  cno varchar(4) primary key,
  cname varchar(20) not null ,
  cpno varchar(4),
  credit tinyint
 )engine=innodb;

create  table  sc(
  sno varchar(6),
  cno varchar(4),
  grade float,
  primary key(sno,cno),
  constraint fk_sno foreign key(sno) references student(sno),
  constraint fk_cno foreign key(cno) references course(cno)
)engine=innodb;

insert into student
values('191001','Tom', 18,'M','CS'),
('191002','Jessica', 19