mysql - 如何向 DATE 字段添加 7 天

Question

我想更新每个 DATE 字段并添加他 7 天。我检查 php 中的 DATE 函数，但没有找到适合 MySQL 语法的函数我的查询是:

$query_sched = "UPDATE events SET events.event_date = DATE(events.event_date + INTERVAL 7)";
$res = mysqli_query($dblink, $query_sched) or die (mysqli_error($dblink));

Answer 1

您缺少一个“+”

UPDATE events SET events.event_date = DATE(events.event_date + interval 7 day) WHERE events.event_id = '$event_id'



UPDATE events SET events.event_date = DATE_ADD(events.event_date , interval 7 day) WHERE events.event_id = '$event_id'

输出:

update test set test.date = date(test.date + interval 7 day) where test.id=1;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0