在实际开发中,对数据的查询占sql操作的90%以上,可见SQL查询是很重要的
首先我们创建三张学习表
创建表
学生表
#创建表 CREATE TABLE LX_student( studentId INT(8) PRIMARY KEY NOT NULL, studentName VARCHAR(8) NOT NULL, studentSex VARCHAR(2) NOT NULL, Birthday DATE NOT NULL, Nation VARCHAR(6) NOT NULL, Address VARCHAR(20) NOT NULL, majorId INT(4), stuResume TEXT, stuCertificate BLOB, FOREIGN KEY (majorId) REFERENCES LX_major(majorId) ); #插入数据 INSERT INTO LX_student(studentId,studentName,studentSex,Birthday,Nation,Address,majorId) VALUES (06053113,'唐李生','男','1987-4-19','汉','湖北省麻城',0501), (07042219,'黄耀','男','1989-1-2','汉','黑龙江省牡丹江市',0403), (06041138,'华美','女','1987-9-11','汉','河北省保定市',0403), (07045120,'刘权利','男','1989-10-20','回','湖北省武汉市',0403), (08055117,'王燕','女','1990-10-20','回','河南省安阳市',0501), (08045142,'郝明星','女','1989-11-29','满','辽宁省大连市',0403), (08053101,'高猛','男','1990-2-3','汉','湖北生黄石市',0501), (08053124,'多桑','男','1988-10-26','藏','西藏',0501), (08053160,'郭政强','男','1986-11-24','土家','湖南省吉首',0501), (08053116,'陆敏','女','1990-8-3','汉','广东省东莞',0501), (08053131,'林惠萍','女','1989-4-12','壮','广西省柳州市',0501), (07093305,'郑家谋','男','1988-9-12','汉','上海市',0904), (07093342,'罗家艳','女','1988-5-16','满','北京市',0904), (07093325,'史玉磊','男','1988-9-11','汉','湖北省孝感市',0904), (07093317,'凌晨','女','1988-6-28','汉','浙江省温州',0904), (08041136,