MySQL查询值($1，$2)[ req.body.number1，req.body.number2]是否不起作用？

Question

这个查询的错误是，如果我将$1，$2，$3，$4，$5替换为它工作的实际值，

这是我的代码。

  let queryText = "INSERT INTO`calculator_challenge`.`calculations`
(`number1`, `operator`, `number2`, `total`, `created_at`) 
VALUES ($1, $2, $3, $4, $5);";

  pool.query(queryText, [calc_obj.number1, calc_obj.operator, calc_obj.number2, calc_obj.total, calc_obj.created_at], (error, result, fields) => {
    if (error) throw error;
    res.send(JSON.stringify(result));
  });
});

Answer 1

更新代码如下：(我包含了一些引号)

let queryText = "INSERT INTO`calculator_challenge`.`calculations`(`number1`, `operator`, `number2`, `total`, `created_at`) VALUES ('$1', '$2', '$3', '$4', '$5')";