数据库第三次作业--新增数据

原创已于 2022-03-17 11:25:30 修改 · 1.3k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#linq #c# #mysql

于 2022-03-15 18:17:12 首次发布

这篇博客展示了如何在教师、课程和授课表中进行数据插入，包括指定字段插入、所有字段插入、批量插入和指定字段批量插入。示例涵盖了教师的职称、工资和岗位津贴，课程的课时数，以及授课的周数和教室信息。

如下表新增数据：

指定字段插入数据时若插入值为空时，无需指定该字段名，

教师表 teacher
1. 指定字段插入数据

教师号	教师姓名	职称	工资	岗位津贴
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)

查看：

1. 所有字段插入数据

教师号	教师姓名	职称	工资	岗位津贴
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)

查看

1. 所有字段批量插入数据

教师号	教师姓名	职称	工资	岗位津贴
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)

查看

1. 指定字段批量插入数据

教师号	教师姓名	职称	工资	岗位津贴
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)

查看

1. 查看教师表中教师号、教师姓名、职称、工资字段数据

课程表 course
1. 指定字段插入数据

课程号	课程名	课时数
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)

查看

1. 所有字段插入数据

课程号	课程名	课时数
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)

查看

1. 所有字段批量插入数据

课程号	课程名	课时数
C5	Flash	50
C6	marketing

输入

insert into course values
-> ("c5","flash","50"),
-> ("c6","marketing","0");

查看

1. 指定字段批量插入数据

课程号	课程名	课时数
C7	Situation and Policy
C8	Patriotic education

输入

insert into course(no,name,class_hours) values
-> ("c7","Situation and Policy","0"),
-> ("c8","Patriotic education","0");

输入

查看

1. 查看课程表中课程号、课程名、课时数字段数据

授课表 school_teaching
1. 指定字段插入数据

序号	课程号	教师号	周数	教室号
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");

查看

1. 所有字段插入数据

序号	课程号	教师号	周数	教室号
	C3	T2	16	J101
4	C3	T3		J302

输入

mysql> insert into school_teaching values
-> ("3","c3","t2","16","y101"),
-> ("4","c3","t3","0","y302");

查看

1. 所有字段批量插入数据

序号	课程号	教师号	周数	教室号
	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");

查看

1. 指定字段批量插入数据

序号	课程号	教师号	周数	教室号
	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)

查看

1. 查看教师表所有字