How to insert multiple MySQL records in node.js -
i want insert multiple data mysql using node.js, have created code worked single data insert (1 column), code :
var data = "how you"; db.query('insert message (message) values (?)', data)
then tryed insert multiple records got error code is
var senderid='00012'; var message='this node'; db.query('insert message (senderid, message) values (?, ?)', senderid, message)
please solve problem
var userid=msg.userid; var msg=msg.message; db.query('insert message (senderid, message) ' + 'values ("'+userid+'", "'+msg+'")', function(err) { console.log(err); });