Mysql——建表

--drop database student

create database student--创建数据库student


use student --从数据库student中
create table Course--建立Course表
(
	Cno int not null primary key identity(1,1),--建立列名和类型，使用了主键
	Cname nvarchar(10),
	Cpno int,
	Ccredit int
)
select * from Course--搜索表Course

insert Course(Cname,Cpno,Ccredit)--插入
values('数据库','5','4')
insert Course(Cname,Ccredit)
values('数学','2')
insert Course
values('信息系统','1','4')
insert Course
values('操作系统','6','3')
insert Course
values('数据结构','7','4')
insert Course(Cname,Ccredit)
values('数据处理','2')
insert Course
values('PASCAL语言','6','4')




create table Student
(
	Sno char(10) not null,
	Sname nvarchar(10),
	Ssex char(10),
	Sage int,
	Sdept char(10)
)
select * from Student

insert Student
values('95001','李勇','男','20','CS')
insert Student
values('95002','刘晨','女','19','IS')
insert Student
values('95003','王敏','女','18','MA')
insert Student
values('95001','张立','男','19','IS')


create table Sc
(
	Sno char(10),
	Cno int,
	Grade int
)
select * from Sc
insert Sc
values('95001','1','92')
insert Sc
values('95001','2','85')
insert Sc
values('95001','3','88')
insert Sc
values('95002','2','90')
insert Sc
values('95002','3','80')