最新数据库实验 学生宿舍管理系统设计大作业(10)

2.3.1 导入数据

/*导入学生基本信息*/

insert into student values('08052201','David','man','20','19900205','jilin','15804254751','science','massage','082','20080907');

insert into student values('08052202','lucy','woman','21','19890205','liaoning','15804254765','science','massage','082','20080907');

insert into student values('08052203','jim','man','20','19900206','hunan','15804254756','computer','software','084','20080907');

insert into student values('08052204','Tom','man','22','19880205','hubei','15804254753','economy','sale','082','20080907');

insert into student values('08052205','lily','woman','20','19900405','jilin','15804254759','science','massage','084','20080907');

insert into student values('08052206','anne','woman','21','19890208','beijing','15804254761','science','math','081','20080907');

insert into student values('08052207','Tim','man','20','19900206','henan','15804254758',

'computer','software','083','20080907');

insert into student values('08052208','harry','woman','20','19900205','liaoning','15804254741','science','massage','082','20080907');

insert into student values('08052209','rose','woman','20','19900511','shanghai','15804298781','science','math','082','20080907');

insert into student values('08052210','jack','man','20','19900212','nanjing','15804255551','science','massage','081','20080907');

insert into student values('08052211','arce','woman','19','19910205','hubei','15804254351','science','massage','081','20080907');

insert into student values('08052212','roon','man','20','19900205','jilin','15804254751','science','massage','082','20080907');

insert into student values('08052213','hong','woman','21','19900225','zhejiang','15904258754','science','math','082','20080907');

insert into student values('08052214','wen','man','20','19901105','shengyang','15804254341','language','news','083','20080907');

insert into student values('08052215','li','man','20','19900305','heilongjiang','15804345651','science','massage','081','20080907');

insert into student values('08052216','Dmdn','woman','20','19900508','henan','15804254532','computer','software','083','20080907');

insert into student values('08052217','jiao','woman','20','19900423','liaoning','15804253478','science','math','083','20080907');

insert into student values('08052218','jili','man','19','19910205','jilin','15804254737','science','massage','081','20080907');

insert into student values('08052219','lan','woman','20','19900805','shanxi','15800596751','science','math','083','20080907');

insert into student values('08052220','grey','man','20','19900315','jilin','15804254432','science','massage','082','20080907');