/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

17 votes129 views2 answers
Nodejs make directory
Javascript Node.js
0 vote111 views1 answer
Node spawn bash catch errors
Javascript Node.js
0 vote116 views1 answer
Set path of index html meta tag using node js
Javascript Node.js
-1 vote115 views1 answer
Nodejs read file to array
Javascript Node.js
7 votes114 views6 answers
What is node js
Javascript Node.js
6 votes119 views3 answers
Get random number node js
Javascript Node.js
0 vote120 views1 answer
How to redirect 404 errors to a page in node js server?
Javascript Node.js
8 votes121 views2 answers
Node js error
Javascript Node.js
7 votes116 views5 answers
Update in mongoose node js
Javascript Node.js
0 vote132 views1 answer
Screen.render is not a function in node
Javascript Node.js