📄 浙大2002届新生名册.sql
字号:
insert into student values (25 ,'02110104150313','040550923','郝姗','女','1984/1/22','安吉县高级中学','110104198401220825','北京市宣武区后孙公园胡同19号','100052','83166831', 591 , 581 ,'英语(经贸英语)','满族','团员','北京市','宣武区');
insert into student values (26 ,'02110104150331','040150615','周瑞','女','1984/7/15','安吉县高级中学','110104198407151621','北京市宣武区右安门内西街甲2号内11楼6门302','100054','83513769 13701181960', 634 , 634 ,'建筑学','汉族','团员','北京市','宣武区');
insert into student values (27 ,'02110104152095','040150218','张妍','女','1983/3/30','安吉县高级中学','110102198303300466','北京市宣武区里仁街育人里小区五号楼2门602室','100054','83584692', 436 , 436 ,'艺术设计','汉族','团员','北京市','宣武区');
insert into student values (28 ,'02110104152217','041051123','段一峰','男','1983/5/20','安吉县高级中学','110102198305202317','北京市宣武区红莲中里23号楼1501房间','100055','63423437 13683343266', 513 , 513 ,'土木工程','汉族','团员','北京市','宣武区');
insert into student values (29 ,'02110104152254','040151228','杨子端','男','1984/2/11','安吉县高级中学','110104198402110038','北京市朝阳区华威西里41楼502号','100021','67768871', 586 , 586 ,'国际经济与贸易','汉族','团员','北京市','宣武区');
insert into student values (30 ,'02110105150283','050151806','汤群','女','1983/8/18','安康中学','110105198308181127','北京市朝阳区金台里24楼1单元906','100026','85992381 13681283772', 624 , 624 ,'电子信息工程(信电系)','汉族','团员','北京市','朝阳区');
insert into student values (31 ,'02110105152206','050351006','钱自强','男','1984/3/25','安陆第一高级中学','460102198403252414','北京市朝阳区劲松八区828楼3门12号','100021','67749191', 592 , 582 ,'热能与动力工程','汉族','团员','北京市','朝阳区');
insert into student values (32 ,'02110105154222','050550910','徐涛','男','1984/7/19','安陆第一高级中学','110105198407191136','北京市朝阳区农光南路18楼1102#','100021','67343015', 580 , 580 ,'英语(经贸英语)','汉族','团员','北京市','朝阳区');
insert into student values (33 ,'02110105157010','050850610','徐秉辉','男','1984/5/12','安庆二中','110105198405128619','北京市朝阳区安贞里一区21楼1106号','100029','64424824', 577 , 567 ,'过程装备与控制工程','汉族','团员','北京市','朝阳区');
insert into student values (34 ,'02110108150004','080152311','胡宇鹏','男','1984/4/7','安庆二中','110108198404073731','北京市海淀区玉海园五里2号楼6单元202室','100039','68249300 68385220', 626 , 626 ,'电子信息工程(信电系)','汉族','团员','北京市','海淀区');
insert into student values (35 ,'02110108150023','080151120','孟小舟','男','1983/9/11','安庆市招生办','110108198309113715','北京市海淀区复兴路79号617楼1单元15号','100039','68389083', 577 , 577 ,'测控技术与仪器','汉族','团员','北京市','海淀区');
insert into student values (36 ,'02110108150039','080651206','金戎','女','1984/3/6','安庆一中','110108198403064921','北京市海淀区羊坊店铁路第一住宅中楼一单元2号','100038','63954429 13901146855', 604 , 604 ,'生物医学工程','汉族','群众','北京市','海淀区');
insert into student values (37 ,'02110108152347','081650429','刘潇潇','女','1984/3/6','安庆一中','110108198403065465','北京市海淀区增光路甲44号院1门4号刘晓风转','100037','68453575 13701018499', 580 , 580 ,'国际经济与贸易','汉族','团员','北京市','海淀区');
insert into student values (38 ,'02110108152538','081651404','孙彤','女','1983/12/28','安庆一中','110108198312285446','北京市海淀区万寿路西街11号育英学校宿舍楼3号楼204号','100036','68187623 13701100311', 614 , 604 ,'数学与应用数学','汉族','团员','北京市','海淀区');
insert into student values (39 ,'02110108152768','082350901','陈景辉','男','1984/6/27','安庆一中','110108198406277113','北京市海淀区中关村南大街12号中国农业科学院文献中心陈焕生收','100081','62147363 68919917', 609 , 589 ,'工商管理','汉族','团员','北京市','海淀区');
insert into student values (40 ,'02110108152921','082351024','辛业','男','1984/3/1','安庆一中','11010819840301975X','北京市海淀区北京大学医学部宿舍13楼2门101号','100083','64873628 62092017', 583 , 583 ,'计算机科学与技术','汉族','团员','北京市','海淀区');
insert into student values (41 ,'02110108155230','083852208','梅旭','男','1984/6/1','安庆一中','110108198406011411','北京市海淀区中关村85楼302#','100080','62544506 13601206869', 546 , 546 ,'通信工程','汉族','团员','北京市','海淀区');
insert into student values (42 ,'02110108155458','083851725','祝芳','女','1983/11/6','安庆一中','110108198311060026','北京市海淀区中关村大街29号海淀医院住院处王溪平转祝芳收','100080','62481399 62583014', 619 , 609 ,'英语(经贸英语)','汉族','团员','北京市','海淀区');
insert into student values (43 ,'02110108155860','084051107','毛宇','男','1984/5/31','安丘四中','110108198405316010','北京市海淀区清华大学一公寓28号','100084','62787378', 581 , 581 ,'热能与动力工程','汉族','团员','北京市','海淀区');
insert into student values (44 ,'02110108155946','084050608','罗娓娓','女','1984/11/2','安丘一中','110108198411021120','北京市海淀区中共中央党校120楼606号','100091','62807157/13601078161', 542 , 542 ,'法学','汉族','群众','北京市','海淀区');
insert into student values (45 ,'02110108156130','083851524','吴连子','女','1984/7/8','安丘一中','110221198407085929','北京市昌平区马池口镇白浮村723#','102200','60771565 13901229026', 614 , 604 ,'电子商务(管理学院)','满族','团员','北京市','海淀区');
insert into student values (46 ,'02110108157395','083851218','冯高阳','男','1984/6/15','安丘一中','110108198406155415','北京市海淀区三里河路9号院乙3楼2406','100037','68394566 68394089', 599 , 599 ,'电子科学与技术','汉族','团员','北京市','海淀区');
insert into student values (47 ,'02110108157427','084851504','陶瑫','男','1984/5/12','安师大附中','110108198405120034','北京市海淀区海淀南路6楼7门1203#','100080','62531064', 612 , 612 ,'电子信息工程(电气学院)','汉族','团员','北京市','海淀区');
insert into student values (48 ,'02110108157461','084151118','吴翔','男','1984/5/13','安顺地区二中','110108198405134217','北京市海淀区复兴路61号院东1楼4门303#','100036','68286778 68675113', 579 , 579 ,'工业设计','汉族','团员','北京市','海淀区');
insert into student values (49 ,'02110108157487','084850309','邢燕雁','女','1984/4/2','安顺市第一高级中学','110102198404022346','北京市西城区南礼士路地藏庵5楼3门11号','100045','68037458 66335831', 507 , 507 ,'金融学','汉族','团员','北京市','海淀区');
insert into student values (50 ,'02110111150964','110350419','金平','女','1984/4/24','安溪一中','110111198404242628','北京市房山区崇各庄乡晓幼营村五区46号','102471','60301971', 579 , 579 ,'工业设计','汉族','团员','北京市','房山区');
insert into student values (51 ,'02110112150560','120150323','冯骏','男','1983/6/9','安溪一中','110111198306098634','北京市燕化公司杏花东里14楼3/401#','102500','69331313', 608 , 608 ,'金融学','汉族','团员','北京市','燕 化');
insert into student values (52 ,'02110222150010','220151624','范旭','女','1983/2/12','安阳市第一中学','110222830212162','北京市顺义区赵全营镇西小营村','101301','69495142 69491946', 584 , 584 ,'机械工程及其自动化','汉族','团员','北京市','顺义区');
insert into student values (53 ,'02110222150377','220152330','张富旺','男','1982/11/15','安阳市第一中学','110105821115523','北京市朝阳区北京金盏车桥厂','100018','84315945 84318903', 617 , 617 ,'自动化(控制系)','汉族','团员','北京市','顺义区');
insert into student values (54 ,'02110223151085','230350730','高军','男','1982/11/21','安阳市实验中学','230102821121433','北京市通州区运河中学','101100','13910606138', 585 , 585 ,'工商管理','汉族','团员','北京市','通州区');
insert into student values (55 ,'02110224150006','240150216','吕希永','男','1984/3/11','安岳县安岳中学','11022419840311033X','北京市大兴区黄村镇车站中里21楼4/101#','......','61214952', 583 , 573 ,'心理学类','汉族','团员','北京市','大兴区');
insert into student values (56 ,'02110226151347','260151228','任宝祥','男','1983/11/30','鞍山市第三中学','110226831130051','北京市平谷县北京师范大学平谷附属中学','101200','69951381', 593 , 583 ,'物理学','汉族','团员','北京市','平谷区');
insert into student values (57 ,'02110226151869','260151813','周毅','男','1982/10/31','鞍山市第一中学','131082198210310412','河北省三河市司法局周东波','065200','13803220652', 631 , 631 ,'自动化(电气学院)','汉族','中共党员','北京市','平谷区');
insert into student values (58 ,'02110226151870','260151811','季科','男','1983/10/12','鞍山市第一中学','130103831012181','河北省石家庄市裕华区东风东路祥龙花园3栋3单元202室','050000','13803375566', 612 , 612 ,'建筑学','汉族','团员','北京市','平谷区');
insert into student values (59 ,'02110108112253',null,'刘婧巍','女','1983/10/1','鞍山市第一中学','110108831028046',null,null,null, 452 , 452 ,'艺术设计','汉族',null,'北京市',null);
insert into student values (60 ,'02120101910516','910102141','李善川','女','1984/4/18','鞍山市第一中学','120101840418152','天津市和平区泰安道五号市委组织部宣教科技干部处','300040',null, 523 , 523 ,'法学','汉族','团员','天津市','和平区');
insert into student values (61 ,'02120101912503','910102152','陈岩','男','1983/7/1','鞍山市第一中学','120101830701153','天津市河西区绍兴道元兴新里49门111/114','300204',null, 585 , 585 ,'劳动与社会保障','汉族','团员','天津市','和平区');
insert into student values (62 ,'02120101950005','950103732','石浩然','男','1984/2/23','鞍山市第一中学','120103840223381','天津市河西区爱国道前程里46号601','300200',null, 620 , 620 ,'机械工程及其自动化','汉族','团员','天津市','和平区');
insert into student values (63 ,'02120101950015','950141240','杨斌','男','1983/8/17','鞍山市第一中学','120102830817501','天津市河东区津塘路红旗巷四条3/2/505','300180',null, 656 , 656 ,'信息工程(光电系)','汉族','团员','天津市','和平区');
insert into student values (64 ,'02120101950021','950141262','高喆','男','1983/8/24','鞍山市第一中学','120101830824351','天津市南开区博爱道博彩公寓2号楼2门601','300381',null, 641 , 641 ,'生物医学工程','汉族','团员','天津市','和平区');
insert into student values (65 ,'02120101950065','950103852','康琳','男','1983/12/3','鞍山市第一中学','120102831203125','天津市河东区大桥道金昌里6号楼3单元409','300170',null, 637 , 637 ,'数学与应用数学','汉族','团员','天津市','和平区');
insert into student values (66 ,'02120101950088','950101571','暴晖','女','1984/1/4','鞍山市海城市高级中学','120101840104152','天津市和平区福安大街和平园1门701','300021',null, 640 , 640 ,'数学与应用数学','汉族','团员','天津市','和平区');
insert into student values (67 ,'02120101950197','950103702','蔡葵','女','1983/9/27','鞍山市海城市往届生','120106830927106','天津市河西区平山道5号403号','300074',null, 635 , 635 ,'电子信息工程(信电系)','汉族','团员','天津市','和平区');
insert into student values (68 ,'02120101950269','950141022','刘寿海','男','1984/1/22','鞍山市铁东区往届生','120109840122701','天津市大港区世纪大道191号大港第一中学','300270',null, 636 , 636 ,'电子商务(经济学院)','汉族','团员','天津市','和平区');
insert into student values (69 ,'02120101950298','950141252','刘莎','女','1983/8/15','八十中学','120101830815302','天津市(和)河沿道卫华里56门308','300070',null, 630 , 630 ,'化学工程与工艺','汉族','团员','天津市','和平区');
insert into student values (70 ,'02120101950506','950101471','穆德为','男','1983/7/27','巴盟中学','120101830727101','天津和平区哈尔滨道7号','300041',null, 509 , 509 ,'美术学','汉族','团员','天津市','和平区');
insert into student values (71 ,'02120101950512','950103850','王洋','男','1984/3/11','巴县中学','120101840311051','天津市和平区赤峰道128号2楼','300041',null, 631 , 621 ,'地理信息系统','汉族','团员','天津市','和平区');
insert into student values (72 ,'02120101950645','950103922','杨赫','男','1983/7/27','巴州和硕县马兰中学','120102830727125','天津市河东区红星路汇贤南里1/3/501','300170',null, 648 , 638 ,'数学与应用数学','汉族','团员','天津市','和平区');
insert into student values (73 ,'02120101950764','950103752','刘卓扬','男','1983/12/7','巴州华山中学','120106831207007','天津市红桥区咸阳北路清源楼3门301','300131',null, 631 , 631 ,'物理学','汉族','团员','天津市','和平区');
insert into student values (74 ,'02120101950780','950103670','侯震坤','女','1984/5/16','巴州华山中学','120105840516542','天津市河北区靖江路涪江北里10号楼14栋301','300251',null, 617 , 617 ,'英语(经贸英语)','汉族','团员','天津市','和平区');
insert into student values (75 ,'02120101950781','950141250','刘妍','女','1983/7/1','巴州华山中学','120105830701214','天津市河北区六马路调纬路调丰里12号401','300142',null, 624 , 624 ,'化学工程与工艺','汉族','团员','天津市','和平区');
insert into student values (76 ,'02120101950802','950103691','何旻','男','1983/5/30','巴州农二师八一中学','120103830530263','天津市河西区新围堤道6号天津市第二中级人民法院','300210',null, 644 , 644 ,'化学工程与工艺','汉族','团员','天津市','和平区');
insert into student values (77 ,'02120101950910','950103900','殷亚迪','男','1984/9/30','鲅鱼圈高中','120101198409303513','天津市河北区中山路中宇里1楼2门601','300141',null, 644 , 644 ,'电子信息工程(信电系)','汉族','团员','天津市','和平区');
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -