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

今日目标：Mysql学习36

实验内容：

-- 35. 查询student 中每个学生的姓名和年龄(当前时间 - 出生年份)

SELECT s_name, YEAR(NOW()) - YEAR(s_birthday) AS age FROM student;

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

| s_name | age  |

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

| 曾华   |   42 |

| 匡明   |   44 |

| 王丽   |   43 |

| 李军   |   43 |

| 王芳   |   44 |

| 陆军   |   45 |

| 王尼玛 |   43 |

| 张全蛋 |   44 |

| 赵铁柱 |   45 |

| 张飞   |   45 |

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

 

 

-- 36. 查询student中最大和最小的 s_birthday的值

SELECT MAX(s_birthday),MIN(s_birthday) FROM student;

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

| MAX(s_birthday)     | MIN(s_birthday)     |

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

| 1977-09-01 00:00:00 | 1974-06-03 00:00:00 |

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