/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

-1 vote212 views1 answer
Get home directory in nodejs windows
Javascript Node.js
11 votes179 views4 answers
Node express setup
Javascript Node.js
0 vote165 views1 answer
API version control v1 v2 in NodeJs (loosely coupled)
Javascript Node.js
0 vote178 views1 answer
Tskill nodejs port
Javascript Node.js
0 vote169 views1 answer
Node fs full path
Javascript Node.js
0 vote184 views1 answer
Passing variable in table row delete button node js express
Javascript Node.js
0 vote206 views1 answer
Node js load css file
Javascript Node.js
0 vote186 views1 answer
Transaction commit rollback nodejs
Javascript Node.js
0 vote161 views1 answer
Find date range btween start date to end date in node js
Javascript Node.js
4 votes185 views1 answer
Nodejs readdir
Javascript Node.js