1.掌握数据表的创建。2.掌握数据表的插入
--创建学生表
CREATE TABLE IF NOT EXISTS `Student`(
`Sno` VARCHAR(20) NOT NULL,
`Sname` VARCHAR(20) NOT NULL,
`Ssex` VARCHAR(20) NOT NULL,
`Sbirthday` DATE,
`Class` VARCHAR(20),
PRIMARY KEY ( `Sno` )
)
--创建课程表
CREATE TABLE IF NOT EXISTS `Course`(
`Cno` VARCHAR(20) NOT NULL,
`Cname` VARCHAR(20) NOT NULL,
`Tno` VARCHAR(20) NOT NULL,
PRIMARY KEY ( `Cno` ),
foreign key(Tno) references 教职工表(主键)
)
go
--插入数据 -课程表
INSERT INTO Student ( Sno, Sname,Ssex,Sbirthday,Class )VALUES( '108', '曾华','男','1977-09-01','95033');
INSERT INTO Student ( Sno, Sname,Ssex,Sbirthday,Class )VALUES( '105', '匡明 ','男','1975-10-02','95031');
INSERT INTO Student ( Sno, Sname,Ssex,Sbirthday,Class )VALUES( '107', '王丽','女','1976-01-23','95033');
INSERT INTO Student ( Sno, Sname,Ssex,Sbirthday,Class )VALUES( '101', '李军','男','1976-02-20','95033');
INSERT INTO Student ( Sno, Sname,Ssex,Sbirthday,Class )VALUES( '109', '王芳','女','1975-02-10','95031');
INSERT INTO Student ( Sno, Sname,Ssex,Sbirthday,Class )VALUES( '103', '陆军','男','1974-06-03','95031');
go
--插入数据 -学生表
INSERT INTO Course ( Cno, Cname,Tno )VALUES( '3-105', '计算机导论','825');
INSERT INTO Course ( Cno, Cname,Tno )VALUES( '3-245', '操作系统','804');
INSERT INTO Course ( Cno, Cname,Tno )VALUES( '6-166', '数字电路','856');
INSERT INTO Course ( Cno, Cname,Tno )VALUES( '9-888', '高等数学','831');
go
有没有详细的步骤截图和结果截图呢