[Node.js] mysql query error
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); });
위와 같이 작성해야 맞습니다.