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 '' at line 1",
sqlState: '42000',
index: 0,
sql: 'insert into orders set'
}
这个错误问题在哪里呀
我的代码如下
router.post('/add_order', (req, res) => {
let sql = "insert into orders set?"
let params = req.body
db(sql, params, (result) => {
if(result.affectedRows == 1){
res.json({
code: 200,
msg: "加入订单数据成功"
})
}else{
res.json({
code: 201,
msg: "加入订单数据失败"
})
}
})
})