如下表新增数据:
指定字段插入数据时若插入值为空时,无需指定该字段名,
- 教师表 teacher
- 指定字段插入数据
教师号 | 教师姓名 | 职称 | 工资 | 岗位津贴 |
T1 | Anne | Professor | 5000 | 2000 |
T2 | Adam | 2000 | ||
T3 | Alan | Associate Professor | 4000 | 1500 |
T4 | Ben | 2000 | 500 | |
T5 | Bob | Lecturer | 3000 |
输入: insert into teacher (no,name,prof,sal,comm)
-> values ("T1","Anne","professor","5000","2000"),
-> ("T2","Adam","0","2000","0"),
-> ("T3","Alan","Associate professor","4000","1500"),
-> ("T4","Ben","0","2000","500"),
-> ("T5","Bob","Lecturer","3000","0");
Query OK, 5 rows affected (0.01 sec)
查看:
-
- 所有字段插入数据
教师号 | 教师姓名 | 职称 | 工资 | 岗位津贴 |
T6 | Brant | Lecturer | 3000 | |
T7 | Bruce | Teaching Assistant | 2000 | 500 |
输入代码:insert into teacher values ("T6","brant","lecturer","3000","1500"),("T7","bruce","teaching Assistant","3000","1000");
Query OK, 2 rows affected (0.01 sec)
查看
-
- 所有字段批量插入数据
教师号 | 教师姓名 | 职称 | 工资 | 岗位津贴 |
T8 | Cary | Associate Professor | 4000 | 1500 |
T9 | Chris | 2000 | ||
T10 | Daniel | Lecturer | 3000 | 1000 |
输入
insert into teacher values
-> ("T8","cary","Associate professor","4000","1500"),
-> ("T9","chris","0","2000","0"),
-> ("T10","daniel","Lecturer","3000","1000");
Query OK, 3 rows affected (0.01 sec)
查看
-
- 指定字段批量插入数据
教师姓名 | 职称 | 工资 | 岗位津贴 | |
T11 | David | Associate Professor | 4000 | |
T12 | Edward | Teaching Assistant | 2000 | |
T13 | Eric | Professor | 5000 |
输入
insert into teacher (no,name,prof,sal,comm)
-> values ("T11","david","Associate professor","4000","0"),
-> ("T12","edward","teaching Assistant","2000","0"),
-> ("T13","eric","professor","5000","0");
Query OK, 3 rows affected (0.01 sec)
查看
-
- 查看教师表中 教师号、教师姓名、职称、工资 字段数据
- 课程表 course
- 指定字段插入数据
课程号 | 课程名 | 课时数 |
C1 | Mysql | 80 |
C2 | cloud computing |
输入
insert into course(no,name,class_hours) values
-> ("c1","mysql","80"),
-> ("c2","cloud computing","0");
Query OK, 2 rows affected (0.01 sec)
查看
-
- 所有字段插入数据
课程号 | 课程名 | 课时数 |
C3 | Professional English | 30 |
C4 | Network foundation |
输入
insert into course values
-> ("c3","Professional English","30"),
-> ("c4","Network foundation","0");
Query OK, 2 rows affected (0.01 sec)
查看
-
- 所有字段批量插入数据
课程号 | 课程名 | 课时数 |
C5 | Flash | 50 |
C6 | marketing |
输入
insert into course values
-> ("c5","flash","50"),
-> ("c6","marketing","0");
查看
-
- 指定字段批量插入数据
课程名 | 课时数 | |
C7 | Situation and Policy | |
C8 | Patriotic education |
输入
insert into course(no,name,class_hours) values
-> ("c7","Situation and Policy","0"),
-> ("c8","Patriotic education","0");
输入
查看
-
- 查看课程表中 课程号、课程名、课时数 字段数据
- 授课表 school_teaching
- 指定字段插入数据
序号 | 课程号 | 教师号 | 周数 | 教室号 |
1 | C1 | T1 | 13 | Y201 |
C2 | T1 | Y202 |
输入
insert into school_teaching(id, course_no,teacher_no,week,class_num) values
-> ("1","c1","t1","13","y201"),
-> ("2","c2","t1","0","y202");
查看
-
- 所有字段插入数据
序号 | 课程号 | 教师号 | 周数 | 教室号 |
C3 | T2 | 16 | J101 | |
4 | C3 | T3 | J302 |
输入
mysql> insert into school_teaching values
-> ("3","c3","t2","16","y101"),
-> ("4","c3","t3","0","y302");
查看
-
- 所有字段批量插入数据
序号 | 课程号 | 教师号 | 周数 | 教室号 |
C4 | T4 | J102 | ||
6 | C5 | T6 | 8 | Y402 |
C5 | T7 | 8 | Y401 |
输入
insert into school_teaching values
-> ("5","c4","t4","0","j102"),
-> ("6","c5","t6","8","y402"),
-> ("7","c5","t7","8","y401");
查看
-
- 指定字段批量插入数据
序号 | 课程号 | 教师号 | 周数 | 教室号 |
C6 | T5 | Y303 | ||
C7 | T8 | J201 | ||
C8 | T9 | Y102 |
输入
insert into school_teaching(id, course_no,teacher_no,week,class_num) values
-> ("8","c6","t5","0","y303"),
-> ("9","c7","t8","0","y201"),
-> ("10","c8","t9","0","y102");
Query OK, 3 rows affected (0.01 sec)
查看
-
- 查看教师表所有字