首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >对MySQL运行db查询后无法查看结果

问对MySQL运行db查询后无法查看结果
EN

Stack Overflow用户
提问于 2020-01-06 14:25:05
回答 2查看 46关注 0票数 2

我想在对MySQL with node运行SQL query后得到结果,但不幸的是我遇到了以下问题,我的代码如下:

代码语言:javascript
复制
socket.on("userpass", function (data) {

        var res = data.split(",");

     //  console.log(data);
      console.log(res[1]);
      var username =  res[0];
      var password =  res[1];

         connection.query('SELECT * FROM user WHERE username = ?', username + 'AND password = ?',password, function (err, result, fields) {

            console.log("eror     ",err);
            console.log("result   ",result);
            console.log(fields+"  fields   ");

我的问题如下:

代码语言:javascript
复制
  throw err; // Rethrow non-MySQL errors
      ^

TypeError: this._callback.apply is not a function
    at Query.Sequence.end (D:\chat\node_modules\mysql\lib\protocol\sequences\Sequence.js:83:24)
    at Query._handleFinalResultPacket (D:\chat\node_modules\mysql\lib\protocol\sequences\Query.js:139:8)
    at Query.EofPacket (D:\chat\node_modules\mysql\lib\protocol\sequences\Query.js:123:8)
    at Protocol._parsePacket (D:\chat\node_modules\mysql\lib\protocol\Protocol.js:291:23)
    at Parser._parsePacket (D:\chat\node_modules\mysql\lib\protocol\Parser.js:433:10)
    at Parser.write (D:\chat\node_modules\mysql\lib\protocol\Parser.js:43:10)
    at Protocol.write (D:\chat\node_modules\mysql\lib\protocol\Protocol.js:38:16)
    at Socket.<anonymous> (D:\chat\node_modules\mysql\lib\Connection.js:91:28)
    at Socket.<anonymous> (D:\chat\node_modules\mysql\lib\Connection.js:525:10)
    at Socket.emit (events.js:210:5)
[nodemon] app crashed - waiting for file changes before starting...
EN

回答 2

Stack Overflow用户

回答已采纳

发布于 2020-01-06 14:42:46

你已经这样写了,

代码语言:javascript
复制
socket.on("userpass", function (data) {

    var res = data.split(",");

    //  console.log(data);
    console.log(res[1]);
    var username = res[0];
    var password = res[1];

    connection.query('SELECT * FROM user WHERE username = ? AND password = ?', [username, password], function (err, result, fields) {

        console.log("eror     ", err);
        console.log("result   ", result);
        console.log(fields + "  fields   ");
    });
}
票数 4
EN

Stack Overflow用户

发布于 2020-01-06 14:37:50

像这样做

代码语言:javascript
复制
connection.query(`SELECT * FROM user WHERE username = '${username}' AND password='${password}'`, function (err, result, fields) {
})
票数 1
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/59607561

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档