php - 尝试使用子查询将数据插入字段

Question

我想从我的数据库中填充一个字段，使用带有 timediff 函数的子查询...

在我看来这是一个语法错误。所以这是我的代码:

$sql = "INSERT INTO paros (tipo, descripcion, ho, hf, totaltiempo(select 
timediff(hf, ho) from paros)) values (?,?,?,?,?)";
$q = $pdo->prepare($sql);
$q->execute(array($tipo,$descripcion, $startTime, $endTime, 
$totaltiempo));
Database::disconnect();

我收到这个错误:

Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 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 '(select timediff(hf, ho) from paros)) values ('Paro no programado','Ajuste de pa' at line 1 in C:\xampp\htdocs\oeemoldeo\paros.php:43 Stack trace: #0 C:\xampp\htdocs\oeemoldeo\paros.php(43): PDOStatement->execute(Array) #1 {main} thrown on line 43

Answer 1

确保您的select 根据where 子句只返回一条记录。然后使用:

INSERT INTO paros (tipo, descripcion, ho, hf, totaltiempo) 
select ?, ?, ?, ?, timediff(hf, ho) from paros where ...