/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

0 vote253 views1 answer
Node js performance is not defined
Javascript Node.js
0 vote251 views1 answer
How to rename zip file nodejs
Javascript Node.js
0 vote238 views1 answer
Image downloader extension in nodejs
Javascript Node.js
102 votes291 views6 answers
Nodejs for ubuntu
Javascript Node.js
5 votes245 views2 answers
Socket emit to specific room using nodejs socket.io
Javascript Node.js
17 votes249 views3 answers
Read json file nodejs
Javascript Node.js
0 vote241 views1 answer
Bcrypt always return faslse in node js
Javascript Node.js
0 vote240 views1 answer
Delete single image by using user id in node js mongodb
Javascript Node.js
5 votes232 views2 answers
How to get file size in node js
Javascript Node.js
0 vote249 views1 answer
Node js express mongodb find all documents
Javascript Node.js