使用SQL语句完成MySQL数据库表的创建和数据插入(救救我急用有悬赏)。

1.掌握数据表的创建。2.掌握数据表的插入

img

img

--创建学生表
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

有没有详细的步骤截图和结果截图呢