怎样实现日期功能?
怎样实现日期功能?
我有一个表dateinfo
字段如下
+------------+------------+------------+
| nowdate | begindate | enddate |
+------------+------------+------------+
| 2002-02-09 | 2002-02-08 | 0000-00-00 |
+------------+------------+------------+
我想让enddate=begindate+7;
实现如下:
mysql> update dateinfo set enddate=
DATE_ADD("select begindate from dateinfo",INTERVAL 7 DAY);
不过不能运行,提示信息:
Query OK, 0 rows affected (0.01 sec)
Rows matched: 1 Changed: 0 Warnings: 1
如何解决?