想要联系SQL,那么要创建表一些表,然后插入一些数据。那么我们就创建以下一些表。
第一个学生表(Student)
学生表的字段(SId,Sname,Sage,Ssex)分别表示学生的编号,姓名,出生日期,性别。
create table Student(SId varchar(10),Sname varchar(10),Sage datetime,Ssex varchar(10)); insert into Student values(\'01\' , \'赵雷\' , \'1990-01-01\' , \'男\'); insert into Student values(\'02\' , \'钱电\' , \'1990-12-21\' , \'男\'); insert into Student values(\'03\' , \'孙风\' , \'1990-05-20\' , \'男\'); insert into Student values(\'04\' , \'李云\' , \'1990-08-06\' , \'男\'); insert into Student values(\'05\' , \'周梅\' , \'1991-12-01\' , \'女\'); insert into Student values(\'06\' , \'吴兰\' , \'1992-03-01\' , \'女\'); insert into Student values(\'07\' , \'郑竹\' , \'1989-07-01\' , \'女\'); insert into Student values(\'09\' , \'张伟\' , \'2017-12-20\' , \'女\'); insert into Student values(\'10\' , \'李伟\' , \'2017-12-25\' , \'女\'); insert into Student values(\'11\' , \'李大\' , \'2017-12-30\' , \'女\'); insert into Student values(\'12\' , \'赵六\' , \'2017-01-01\' , \'女\'); insert into Student values(\'13\' , \'孙七\' , \'2018-01-01\' , \'女\');