Legacy/문제해결

[Node.js] mysql query error

Foo 2017. 1. 15. 01:30
728x90

C:\Users\jun\Documents\MEGA\Dev\nodejs\rest-board\node_modules\mysql\lib\protocol\Parser.js:78

        throw err; // Rethrow non-MySQL errors

        ^


TypeError: this._callback.apply is not a function

    at Query.Sequence.end (C:\Users\jun\Documents\MEGA\Dev\nodejs\rest-board\node_modules\mysql\lib\protocol\sequences\Sequence.js:86:24)

    at Query.ErrorPacket (C:\Users\jun\Documents\MEGA\Dev\nodejs\rest-board\node_modules\mysql\lib\protocol\sequences\Query.js:94:8)

    at Protocol._parsePacket (C:\Users\jun\Documents\MEGA\Dev\nodejs\rest-board\node_modules\mysql\lib\protocol\Protocol.js:280:23)

    at Parser.write (C:\Users\jun\Documents\MEGA\Dev\nodejs\rest-board\node_modules\mysql\lib\protocol\Parser.js:74:12)

    at Protocol.write (C:\Users\jun\Documents\MEGA\Dev\nodejs\rest-board\node_modules\mysql\lib\protocol\Protocol.js:39:16)

    at Socket.<anonymous> (C:\Users\jun\Documents\MEGA\Dev\nodejs\rest-board\node_modules\mysql\lib\Connection.js:109:28)

    at emitOne (events.js:96:13)

    at Socket.emit (events.js:188:7)

    at readableAddChunk (_stream_readable.js:176:18)

    at Socket.Readable.push (_stream_readable.js:134:10)

Program node ./bin/www exited with code 1

connection.query('INSERT INTO users (user_id, password) VALUES (?, password(?))', user_id, password, 
function(err, result) {
    console.log(result);
  });

위와 같이 작성하면 에러가 납니다.


connection.query('INSERT INTO users (user_id, password) VALUES (?, password(?))', [user_id, password], 
function(err, result) {
    console.log(result);
  });


위와 같이 작성해야 맞습니다.