更新现有记录而不删除 mysql 中的字段
代码如下
app.put("/update/:id", (req, res) => {
const userID = req.params.id;
const sql = "UPDATE quotes SET `first_name` = ?, `last_name` = ?, `company` = ?, `email` = ?, `phone` = ? WHERE id = ?"
const values = [my values]
db.query(sql, [...values, userID], (err, data) => {
if (err) return res.send(err)
return res.json(data)
})
})
这是收到的错误
{
"code": "ER_BAD_NULL_ERROR",
"errno": 1048,
"sqlState": "23000",
"sqlMessage": "Column 'first_name' cannot be null",
"sql": "UPDATE quotes SET `first_name` = NULL, `last_name` = NULL, `company` = NULL, `email` = NULL, `phone` = NULL WHERE id = '2'"
}
希望每当更新时,例如,它不会影响其他字段并保持其记录原样first_name