js操作数据库显示操作成功数据库数据不变

Question

提示操作成功但是数据库数据不变

1. ```
   let resl2

try {
console.log(event.shop_id)
resl2 = await mysql.query(" update shop set shop_name=?,top=?,phone=?,describes=?,address=?,is_or_not=? where shop_id=? ",
[event.shop_name,
event.top,
event.phone,
event.describes,
event.address,
event.is_or_not,
event.shop_id])
} catch (e) {
console.error(e)
}
// 创建状态
return {
code: 200,
mess: "成功"
}

```

Answer 1

能正常查询么，mysql.query有自带的事务提交么，还是说需要加一个 commit 提交呢？