MySQL学习笔记(五)

14. 联结表

14.1 联结

联结是利用SQL的select语句能执行的最重要操作

外键：外键是某个表得一列，它包含另一个表的主键值，定义了两个表之间的关系。

14.2 创建联结

mysql> select *from test;
+------+---------+------------------------------------+---------------------+
| t_id | t_name  | t_text                             | t_time              |
+------+---------+------------------------------------+---------------------+
|    5 | Tom     | This is a cat                      | 2019-04-25 16:13:39 |
|    4 | Jerry   | This is a mouse                    | 2019-04-25 15:40:55 |
|    6 | Helen   | She is a student in middle school. | 2019-04-25 16:13:39 |
|    1 | Helen   | NULL                               | 2019-04-25 16:17:21 |
|    3 | Helen   | NULL                               | 2019-04-25 16:17:21 |
|    7 | Erdison | NULL                               | 2019-05-04 00:00:00 |
|    8 | Linda   | NULL                               | 2019-04-02 12:00:00 |
|    9 | Lucy    | NULL                               | 2019-05-01 00:00:00 |
|   10 | Tomson  | NULL                               | 0196-04-23 00:00:00 |
+------+---------+------------------------------------+---------------------+
9 rows in set (0.00 sec)

mysql> select * from _test;
+------+--------+---------------------+
| t_id | _name  | _time               |
+------+--------+---------------------+
|    2 | Linda  | 2019-04-02 12:00:00 |
|    3 | Lucy   | 2019-05-01 00:00:00 |
|    4 | Tomson | 0196-04-23 00:00:00 |
+------+--------+---------------------+
3 rows in set (0.00 sec)

mysql> select t_name,t_time,_name
    -> from test,_test
    -> where test.t_id=_test.t_id
    -> order by t_name;
+--------+---------------------+--------+
| t_name | t_time              | _name  |
+--------+---------------------+--------+
| Helen  | 2019-04-25 16:17:21 | Lucy   |
| Jerry  | 2019-04-25 15:40:55 | Tomson |
+--------+---------------------+--------&#