query multiple records and insert into database using nodejs

Question

For hours now, am trying to query multiple database records and then insert into database using nodejs. The problem is that it only insert one rows per call instead of looping and inserting all database rows at once. can someone help me fix the issue.

con.query("SELECT * FROM users", function (err, result, fields) {


if (err) throw err;
    console.log(result);



//You just insert a nested array of elements.

  var sql = "INSERT INTO customers (name, address) VALUES ?";
  var values = [[result[0].username], result[0].id]];

  con.query(sql, [values], function (err, result) {
    if (err) throw err;
    console.log(" Number of records inserted: " + result.affectedRows);
  });



  });

Nishant Dixit · Accepted Answer · 2018-03-27 15:42:18Z

3

Try this :)

con.query("SELECT * FROM users", function (err, result, fields) {
    if (err) throw err;
    console.log(result);
    if(result && result.length>0) {
        var sql = "INSERT INTO customers (name, address) VALUES ?";
        var values = [];
        for (var i = 0; i < result.length; i++) {
            values.push([result[i].username, result[i].id]);
        }
        con.query(sql, [values], function (err, result) {
            if (err) throw err;
            console.log(" Number of records inserted: " + result.affectedRows);
        });
    }
    else{
        console.log("No data found")
    }
});

answered Mar 27, 2018 at 15:42

Nishant Dixit

5,5125 gold badges22 silver badges32 bronze badges

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

Collectives™ on Stack Overflow

query multiple records and insert into database using nodejs

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