更新 MySQL 日期并增加一年？
您可以使用 MySQL 的内置函数 date_add()。语法如下 -
UPDATE yourTableName SET yourDateColumnName=DATE_ADD(yourDateColumnName,interval 1 year);登录后复制
mysql> create table UpdateDate -> ( -> Id int, -> DueDate datetime -> ); Query OK, 0 rows affected (0.76 sec)登录后复制
mysql> insert into UpdateDate values(1001,'2012-5-21'); Query OK, 1 row affected (0.17 sec) mysql> insert into UpdateDate values(1002,'2013-8-2'); Query OK, 1 row affected (0.17 sec) mysql> insert into UpdateDate values(1003,'2014-2-27'); Query OK, 1 row affected (0.10 sec) mysql> insert into UpdateDate values(1004,'2016-11-1'); Query OK, 1 row affected (0.18 sec) mysql> insert into UpdateDate values(1005,'2017-12-24'); Query OK, 1 row affected (0.12 sec)登录后复制
mysql> select *from UpdateDate;登录后复制登录后复制
