/Javascript/Node.js/Insert multiple Row in SQL database with NodeJS

Insert multiple Row in SQL database with NodeJS

// Function to insert multiple Row in database
let multipleRowInsert = () => {
  
    // Query to insert multiple rows
    let query = `INSERT INTO gfg_table 
        (name, address) VALUES ?;`;
  
    // Values to be inserted
    let values = [
        ['Amit', 'Yellow Park'],
        ['Rishi', 'Park 38'],
        ['Akash', 'Central st 954'],
        ['Pratik', 'Road 989'],
        ['Mangesh', 'Sideway']
    ];
  
    // Executing the query
    db_con.query(query, [values], (err, rows) => {
        if (err) throw err;
        console.log("All Rows Inserted");
    });
};

Source: geeksforgeeks.org

Similar codes

59 votes408 views6 answers
Node Sass version 5.0.0 is incompatible with ^4.0.0.
Javascript Node.js
0 vote340 views1 answer
Front end display data frmo database nodejs html
Javascript Node.js
0 vote389 views1 answer
Calculate init code hash nodejs
Javascript Node.js
0 vote366 views1 answer
Node js to int
Javascript Node.js
1 vote359 views1 answer
Nodejs https server
Javascript Node.js
0 vote340 views1 answer
Redirect to 404 page in node js express
Javascript Node.js
0 vote354 views1 answer
Rfid reader nodejs
Javascript Node.js
1 vote364 views1 answer
Read from s3 bucket nodejs
Javascript Node.js
1 vote386 views1 answer
Node js response header
Javascript Node.js
0 vote364 views2 answers
Ubuntu 18.04 nodejs insatll
Javascript Node.js