--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')
Mysql——建表
最新推荐文章于 2024-04-09 23:17:56 发布