Node.js mysql callback error

Question

I Used node.js and mysql. i Made callback function in mysql query callback.

exports.callback = function(req) 
{
....
    Mysqldb.pool.getConnection(function(err, db) {
        db.query("select * from tbl"), function (err,rows) {      
          db.query("update tbl set id = 1"), function (err, rows){
          }); //update tbl
       });//select tbl
    }); //getconnection
}; //export.callback

Error is update query callback.... error message is

TypeError: this._callback.apply is not a function
at Query.Sequence.end (c:\redfox_server_src\node_modules\mysql\lib\protocol\sequences\Sequence.js:96:24)
at Query.ErrorPacket (c:\redfox_server_src\node_modules\mysql\lib\protocol\sequences\Query.js:94:8)
at Protocol._parsePacket (c:\redfox_server_src\node_modules\mysql\lib\protocol\Protocol.js:274:23)
at Parser.write (c:\redfox_server_src\node_modules\mysql\lib\protocol\Parser.js:77:12)
at Protocol.write (c:\redfox_server_src\node_modules\mysql\lib\protocol\Protocol.js:39:16)
at Socket.<anonymous> (c:\redfox_server_src\node_modules\mysql\lib\Connection.js:96:28)
at emitOne (events.js:77:13)
at Socket.emit (events.js:169:7)
at readableAddChunk (_stream_readable.js:146:16)
at Socket.Readable.push (_stream_readable.js:110:10)

please help me..

Pang · Accepted Answer · 2015-09-23 01:38:49Z

2

You missed a double quotation mark here.

Wrong:

db.query("select * from tbl)

Right:

db.query("select * from tbl")

edited Sep 23, 2015 at 1:38

Pang

10.2k146 gold badges87 silver badges126 bronze badges

answered Sep 23, 2015 at 1:32

sEpmein

231 silver badge6 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Node.js mysql callback error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related