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

今日目标：Mysql学习33

实验内容：

-- 29. 查询所有教师和同学的 name ,sex, birthday

SELECT s_name AS name, s_sex AS sex, s_birthday AS birthday  FROM student

UNION

SELECT t_name AS name, t_sex AS sex, t_birthday AS birthday FROM teacher;

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

| name   | sex | birthday            |

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

| 曾华   | 男  | 1977-09-01 00:00:00 |

| 匡明   | 男  | 1975-10-02 00:00:00 |

| 王丽   | 女  | 1976-01-23 00:00:00 |

| 李军   | 男  | 1976-02-20 00:00:00 |

| 王芳   | 女  | 1975-02-10 00:00:00 |

| 陆军   | 男  | 1974-06-03 00:00:00 |

| 王尼玛 | 男  | 1976-02-20 00:00:00 |

| 张全蛋 | 男  | 1975-02-10 00:00:00 |

| 赵铁柱 | 男  | 1974-06-03 00:00:00 |

| 张飞   | 男  | 1974-06-03 00:00:00 |

| 李诚   | 男  | 1958-12-02 00:00:00 |

| 王萍   | 女  | 1972-05-05 00:00:00 |

| 刘冰   | 女  | 1977-08-14 00:00:00 |

| 张旭   | 男  | 1969-03-12 00:00:00 |

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