Closed dong-lufei closed 3 weeks ago
// 查询所有用户 router.get("/users", async (ctx, next) => { const sql = "SELECT * FROM users" connection.query(sql, (err, results, fields) => { if (err) { console.error(err) ctx.body = { success: false, message: "查询失败" } return } console.log("get", results) ctx.body = { success: true, data: results } }) })
我根路由都访问成功,这个路由咋404,但是数据库写进去了而且读成功,console 那行成功有正确数据
哦,知道原因了,好像是 mysql 造成的。我把 npm i mysql 改用npm i mysql2 就成功了
npm i mysql
npm i mysql2
@dong-lufei Happy to hear that you resolved the issue that you faced!
我根路由都访问成功,这个路由咋404,但是数据库写进去了而且读成功,console 那行成功有正确数据