如何在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 3岁孩子祝福语简短
13 聚餐会祝福语简短
14 祝寿时祝福语简短精辟
15 姐妹结婚快乐祝福语简短
16 领证幽默祝福语简短
17 顾客简短祝福语大全集
18 群里祝福语简短幽默