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);         }); 

Popular posts from this blog