这篇博客展示了如何使用SQL语句批量插入学生信息到`stuinfo`表中，并创建及调用存储过程来查询数据。示例包含了多个学生的详细记录，以及创建带输入参数的存储过程用于筛选成绩。
values(‘13550808001’,‘曾华军’,‘86-08-22’,‘13583020539’,‘广东珠海’,‘Y2T49’);
insert into stuinfo (stuno,stuName,birthday,stutel,stuAddress,classname)
values(‘13551219034’,‘罗燕’,‘83-11-07’,‘13578696856’,‘云南省潞西市’,‘Y2T65’);
insert into stuinfo (stuno,stuName,birthday,stutel,stuAddress,classname)
values(‘13550815003’,‘黄志伟’,‘87-11-13’,‘13643088892’,‘江西会昌县’,‘Y2T50’);
insert into stuinfo (stuno,stuName,birthday,stutel,stuAddress,classname)
values(‘13550815004’,‘涂乾文’,‘86-07-22’,‘2228852’,‘广东珠海’,‘Y2T50’);
insert into stuinfo (stuno,stuName,birthday,stutel,stuAddress,classname)
values(‘13550815015’,‘唐宁’,‘81-07-01’,‘13812309868’,‘广东珠海’,‘Y2T50’);
insert into stuinfo (stuno,stuName,birthday,stutel,stuAddress,classname)
values(‘13550826003’,‘贝然’,‘85-06-13’,‘13882202173’,‘广东珠海’,‘Y2T60’);
insert into stuinfo (stuno,stuName,birthday,stutel,stuAddress,classname)
values(‘13550808019’,‘白生全’,‘86-06-03’,‘8828888’,‘重庆’,‘Y2T49’);
insert into stuinfo (stuno,stuName,birthday,stutel,stuAddress,classname)
values(‘13540925028’,‘沈永强’,‘81-06-23’,‘13588065815’,‘江苏南通市’,‘Y2T50’);
insert into stuinfo (stuno,stuName,birthday,stutel,stuAddress,classname)
values(‘21750710010’,‘张键’,‘85-07-18’,‘8557378’,‘广东江门’,‘Y2T50’);
insert into stuinfo (stuno,stuName,birthday,stutel,stuAddress,classname)
values(‘13550906016’,‘吴家彬’,‘82-09-22’,‘8324282’,‘珠海市斗门区’,‘Y2T52’);
insert into stuinfo (stuno,stuName,birthday,stutel,stuAddress,classname)
values(‘13550912004’,‘邹城廷’,‘85-10-15’,‘8218358’,‘广东珠海’,‘Y2T53’);
insert into stuinfo (stuno,stuName,birthday,stutel,stuAddress,classname)
values(‘13540706014’,‘娄智欣’,‘85-09-21’,‘8545256’,‘江西峡江’,‘Y2T42’);
insert into stuinfo (stuno,stuName,birthday,stutel,stuAddress,classname)
values(‘13550304010’,‘陈迪华’,‘00-01-01’,‘5612698’,‘广东珠海’,‘Y2T42’);
insert into stuinfo (stuno,stuNa
最低0.47元/天 解锁文章
扫一扫
1万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
