如何在MySQL中将算术运算符（+，-，*，/）与INTERVAL关键字的单位值一起使用？
我们可以对INTERVAL关键字的单位值使用算术运算符（+，-，*，/），如下所示-
使用加法（+）
mysql> Select date('2017-10-22' + INTERVAL 2+2 Year) AS 'Date After (2+2)Years';
+------------------------+
| Date After (2+2) Years |
+------------------------+
| 2021-10-22 |
+------------------------+
1 row in set (0.00 sec)减法的使用(-)
mysql> Select date('2017-10-22' + INTERVAL 2-2 Year) AS 'Date After (2-2)Years';
+------------------------+
| Date After (2-2) Years |
+------------------------+
| 2017-10-22 |
+------------------------+
1 row in set (0.00 sec)乘法的使用（*）
mysql> Select date('2017-10-22' + INTERVAL 2*2 Year) AS 'Date After (2*2)Years';
+------------------------+
| Date After (2*2) Years |
+------------------------+
| 2021-10-22 |
+------------------------+
1 row in set (0.00 sec)使用除法（/）
mysql> Select date('2017-10-22' + INTERVAL 2/2 Year) AS 'Date After (2/2) Years';
+------------------------+
| Date After (2/2) Years |
+------------------------+
| 2018-10-22 |
+------------------------+
1 row in set (0.00 sec)热门推荐
10 新年祝福语简短又好听
11 老人去世简短祝福语
12 早上祝福语简短句子
13 伴娘祝福语简短朋友的话
14 祝贺母校祝福语简短英语
15 给儿子新婚祝福语简短
16 藏语生病祝福语大全简短
17 送教授贺卡祝福语简短
18 老爸的祝福语简短独特