mysql - PHP 代码中的 SQL 语法错误 - 将两个值相加

Question

我在 PHP 文件中的 MySQL 代码中不断收到此语法错误。我只是想用这个时间变量来增加/添加表中已有的值。如果有人能帮助我，我将不胜感激。

PHP:

$sql = "UPDATE Aircraft
SET MaintenanceFlightTime = (MaintenanceFlightTime + $MaintenanceDuration),
WHERE AircraftID = $AircraftID";

错误:

UPDATE Aircraft SET MaintenanceFlightTime = (MaintenanceFlightTime + 00:10:00), WHERE AircraftID = 8
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ':10:00), WHERE AircraftID = 8' at line 2

Answer 1

您不能仅将“01:01:01”等字符串添加到时间列，但可以使用ADDTIME()

$MaintenanceDuration = '00:10:00';

$sql = "UPDATE Aircraft
        SET MaintenanceFlightTime = ADDTIME(MaintenanceFlightTime, '$MaintenanceDuration')
        WHERE AircraftID = $AircraftID";