打开指令 mysql -h localhost -P 3306 -u root -p
show databases;
use student;
set names gbk;
create table student (sno char(9) primary key,
sname char(20) unique,
sex char(2),
sage smallint,
sdept char(20)
);
create table course(
cno char(4) primary key,
cname char(40) not null,
cpno char(4),
ccredit smallint,
foreign key(cpno) references course(cno)
);
create table sc (
sno char(9),
cno char(4),
grade smallint,
PRIMARY KEY (sno,cno),
foreign key(sno) references student(sno),
foreign key(cno) references course(cno)
);
Insert into student values('201215121','李勇','男',20,'CS'),('201215122','刘晨','女',19,'CS'),('201215123','王明','女',18,'MA'),('201215125','张立','男',19,'IS');
select * from stu;
insert into course values('2','数学',null,2),('6','数据处理',null,2),('4','操作系统','6',3),('7','PASCAL语言','6',4),('5','数据结构','7',4),('1','数据库','5',4),('3','信息系统','1',4);
insert into sc values('201215121','1',92),('201215121','2',85),('201215121','3',88),('201215122','2',90),('201215122','3',80);
