中不起作用"/>
NodeJS:更新查询在MySQL中不起作用
请考虑以下代码:
const queryString = "SET SQL_SAFE_UPDATES = 0; " +
"UPDATE fire_alarm.sensors " +
"SET smoke_level = " + smokeLevel + ", " +
"carbondioxide_level = " + carbondioxideLevel + ", " +
"sensor_status = '" + sensorStatus + "', " +
"alert_status = '" + alertStatus + "' " +
"WHERE floor_no = " + floorNumber + " AND room_no = " + roomNumber + "; " +
"SET SQL_SAFE_UPDATES = 1;";
connection.query( queryString, function (err, rows) {
if(err){
console.error("Error : " + err);
res.send(err);
return;
}
res.json(rows);
});
执行请求时,我得到的错误是:
{
"code": "ER_PARSE_ERROR",
"errno": 1064,
"sqlMessage": "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UPDATE fire_alarm.sensors SET smoke_level = 6, carbondioxide_level = 6, sensor_s' at line 1",
}
但是当我在MySQL Workbench中运行上述确切查询时,它会正确更新,而不会出现任何SQL错误。这里有什么问题,对此有什么可能的解决方案……?
回答如下:并非您添加到sql查询中的所有变量前后都有单引号。所以你应该更新像更多推荐
NodeJS:更新查询在MySQL中不起作用
发布评论