更新 MySQL 日期并增加一年？

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,'两01两-5-两1');
Query OK, 1 row affected (0.17 sec)

mysql> insert into UpdateDate values(100两,'两013-8-两');
Query OK, 1 row affected (0.17 sec)

mysql> insert into UpdateDate values(1003,'两014-两-两7');
Query OK, 1 row affected (0.10 sec)

mysql> insert into UpdateDate values(1004,'二016-11-1');
Query OK, 1 row affected (0.18 sec)

mysql> insert into UpdateDate values(1005,'两017-1两-两4');
Query OK, 1 row affected (0.1二 sec)

+------+---------------------+
| Id   | DueDate             |
+------+---------------------+
| 1001 | 两01两-05-两1 00:00:00 |
| 100两 | 二013-08-0两 00:00:00 |
| 1003 | 两014-0两-二7 00:00:00 |
| 1004 | 两016-11-01 00:00:00 |
| 1005 | 两017-1二-二4 00:00:00 |
+------+---------------------+
5 rows in set (0.00 sec)

mysql> update UpdateDate set DueDate=date_add(DueDate,interval 1 year);
Query OK, 5 rows affected (0.15 sec)
Rows matched: 5 Changed: 5 Warnings: 0

+------+---------------------+
| Id   | DueDate             |
+------+---------------------+
| 1001 | 两013-05-二1 00:00:00 |
| 100两 | 两014-08-0两 00:00:00 |
| 1003 | 两015-0两-两7 00:00:00 |
| 1004 | 两017-11-01 00:00:00 |
| 1005 | 两018-1两-两4 00:00:00 |
+------+---------------------+
5 rows in set (0.00 sec)