subtitle1.sql

数据插入优化系统,可以非常快的同时插入 上千条信息,

insert into student(stud_id,name, birthday, sex, nation,home,tel,party,resume)
values('01','jack','1972-7-2','男','汉族','山东济南',8234512,'党员','大学');
insert into student(stud_id,name, birthday, sex, nation,home,tel,party,resume)values
('02','tom','1972-5-2','女','汉族','山东济南',8234522,'党员','大学');
insert into student(stud_id,name, birthday, sex, nation,home,tel,party,resume)values
('03','helen','1971-5-2','女','回族','山东烟台',5234522,'团员','中学毕业');
insert into student(stud_id,name, birthday, sex, nation,home,tel,party,resume)values
('04','小英','1972-12-2','女','回族','山东济宁',6234522,'团员','中学毕业');


insert into subtitle(subtitle_id,title)values(1001,'力学');
insert into subtitle(subtitle_id,title)values(1002,'数学');
insert into subtitle(subtitle_id,title)values(1003,'机械工程');
insert into subtitle(subtitle_id,title)values(1004,'应用经济学');
insert into subtitle(subtitle_id,title)values(1005,'政治学');


insert into subjectinfo(subject_id,belong_id,subtitle_id,important,doctor)
values(201011,3,1003,1,1);
insert into subjectinfo(subject_id,belong_id,subtitle_id,important,doctor)
values(201012,2,1002,0,2);
insert into subjectinfo(subject_id,belong_id,subtitle_id,important,doctor)
values(201013,5,1005,1,1);