2020/11/01 刘一辰的JAVA随笔

今日目标：Mysql学习8

实验内容：

teacher  SELECT * FROM teacher;

+------+--------+-------+---------------------+--------+------------+

| t_no | t_name | t_sex | t_birthday          | t_rof  | t_depart   |

+------+--------+-------+---------------------+--------+------------+

| 804  | 李诚   | 男    | 1958-12-02 00:00:00 | 副教授 | 计算机系   |

| 825  | 王萍   | 女    | 1972-05-05 00:00:00 | 助教   | 计算机机系 |

| 831  | 刘冰   | 女    | 1977-08-14 00:00:00 | 助教   | 电子工程系 |

| 856  | 张旭   | 男    | 1969-03-12 00:00:00 | 讲师   | 电子工程系 |

+------+--------+-------+---------------------+--------+------------+

 

score  SELECT * FROM score;

+------+-------+-----------+

| s_no | c_no  | sc_degree |

+------+-------+-----------+

| 103  | 3-105 |        92 |

| 103  | 3-245 |        86 |

| 103  | 6-166 |        85 |

| 105  | 3-105 |        88 |

| 105  | 3-245 |        75 |

| 105  | 6-166 |        79 |

| 109  | 3-105 |        76 |

| 109  | 3-245 |        68 |

| 109  | 6-166 |        81 |

+------+-------+-----------+