-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathsystem_db_teacher.sql
35 lines (35 loc) · 6.18 KB
/
system_db_teacher.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
insert into system_db.teacher (id, name, gender, age, telephone, academy, office, position) values ('2134533', '黄二', '女', 20, '122345678', '食品学院', '203', '教授');
insert into system_db.teacher (id, name, gender, age, telephone, academy, office, position) values ('2108826', '玉婷', '女', 35, '123341279', '医学院', '503', '教授');
insert into system_db.teacher (id, name, gender, age, telephone, academy, office, position) values ('2152129', '张三', '男', 23, '123456789', '信息学院', '301', '院士');
insert into system_db.teacher (id, name, gender, age, telephone, academy, office, position) values ('2779321', '周静', '女', 44, '123617812', '信息学院', '501', '教授');
insert into system_db.teacher (id, name, gender, age, telephone, academy, office, position) values ('2157128', '张利', '男', 30, '124314552', '医学院', '306', '院士');
insert into system_db.teacher (id, name, gender, age, telephone, academy, office, position) values ('2033917', '家辉', '男', 49, '129731199', '建筑学院', '308', '院士');
insert into system_db.teacher (id, name, gender, age, telephone, academy, office, position) values ('2036110', '刘四', '女', 30, '133388888', '爱恩学院', '302', '教授');
insert into system_db.teacher (id, name, gender, age, telephone, academy, office, position) values ('2157129', '华晨', '男', 40, '134315794', '爱恩学院', '208', '教授');
insert into system_db.teacher (id, name, gender, age, telephone, academy, office, position) values ('2067331', '郭七', '男', 29, '143336787', '信息学院', '207', '教授');
insert into system_db.teacher (id, name, gender, age, telephone, academy, office, position) values ('2152127', '吴华', '男', 29, '143526440', '食品学院', '108', '教授');
insert into system_db.teacher (id, name, gender, age, telephone, academy, office, position) values ('2157127', '周身', '男', 40, '143534650', '马克思主义学院', '207', '主任');
insert into system_db.teacher (id, name, gender, age, telephone, academy, office, position) values ('2147293', '淑怡', '女', 36, '144578932', '医学院', '202', '教授');
insert into system_db.teacher (id, name, gender, age, telephone, academy, office, position) values ('2034112', '王一', '男', 43, '144666778', '工程学院', '305', '教授');
insert into system_db.teacher (id, name, gender, age, telephone, academy, office, position) values ('2374993', '家琪', '女', 33, '146782977', '经济管理学院', '208', '教授');
insert into system_db.teacher (id, name, gender, age, telephone, academy, office, position) values ('2691732', '昊天', '男', 40, '147867212', '美术学院', '409', '院士');
insert into system_db.teacher (id, name, gender, age, telephone, academy, office, position) values ('2344821', '俊逸', '女', 34, '152298374', '爱恩学院', '106', '院士');
insert into system_db.teacher (id, name, gender, age, telephone, academy, office, position) values ('2045119', '顾六', '女', 39, '156733676', '经济管理学院', '403', '主任');
insert into system_db.teacher (id, name, gender, age, telephone, academy, office, position) values ('2568344', '浩航', '男', 30, '173582293', '工程学院', '304', '教授');
insert into system_db.teacher (id, name, gender, age, telephone, academy, office, position) values ('2348972', '文博', '女', 50, '173972142', '社会科学院', '202', '主任');
insert into system_db.teacher (id, name, gender, age, telephone, academy, office, position) values ('2764022', '曼文', '女', 46, '175572997', '海洋学院', '205', '院士');
insert into system_db.teacher (id, name, gender, age, telephone, academy, office, position) values ('2035116', '孙五', '男', 37, '176299302', '海洋学院', '204', '院士');
insert into system_db.teacher (id, name, gender, age, telephone, academy, office, position) values ('2036881', '文素', '女', 30, '176356281', '法学院', '209', '教授');
insert into system_db.teacher (id, name, gender, age, telephone, academy, office, position) values ('2394792', '魏玲', '女', 48, '177853782', '美术学院', '204', '教授');
insert into system_db.teacher (id, name, gender, age, telephone, academy, office, position) values ('2948923', '吴华', '男', 39, '178267821', '爱恩学院', '304', '主任');
insert into system_db.teacher (id, name, gender, age, telephone, academy, office, position) values ('2144876', '陈九', '女', 40, '183772993', '食品学院', '402', '主任');
insert into system_db.teacher (id, name, gender, age, telephone, academy, office, position) values ('2298383', '叶丹', '女', 29, '183789811', '法学院', '505', '教授');
insert into system_db.teacher (id, name, gender, age, telephone, academy, office, position) values ('2036106', '李华', '女', 33, '186710084', '信息学院', '202', '教授');
insert into system_db.teacher (id, name, gender, age, telephone, academy, office, position) values ('2337492', '沫子', '女', 33, '187378238', '海洋学院', '208', '主任');
insert into system_db.teacher (id, name, gender, age, telephone, academy, office, position) values ('2849723', '晨合', '男', 40, '187392344', '马克思主义学院', '303', '教授');
insert into system_db.teacher (id, name, gender, age, telephone, academy, office, position) values ('2144972', '浩博', '男', 45, '187973286', '美术学院', '109', '院士');
insert into system_db.teacher (id, name, gender, age, telephone, academy, office, position) values ('2993892', '周洋', '男', 55, '189738462', '工程学院', '301', '主任');
insert into system_db.teacher (id, name, gender, age, telephone, academy, office, position) values ('2139791', '武艺', '男', 47, '189926811', '建筑学院', '308', '主任');
insert into system_db.teacher (id, name, gender, age, telephone, academy, office, position) values ('2873782', '秀珍', '女', 40, '192762173', '医学院', '309', '教授');
insert into system_db.teacher (id, name, gender, age, telephone, academy, office, position) values ('2037382', '斯克', '男', 34, '192783622', '马克思主义学院', '201', '主任');
insert into system_db.teacher (id, name, gender, age, telephone, academy, office, position) values ('2782413', '吴磊', '男', 58, '193867862', '工程学院', '307', '主任');