insert multiple Row in SQL database with NodeJS

Breakable Beetle answered on January 11, 2022 Popularity 9/10 Helpfulness 4/10

answer insert multiple Row in SQL database with NodeJS

insert multiple Row in SQL database with NodeJS

Comment

// 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");
    });
};

Popularity 9/10 Helpfulness 4/10 Language javascript

Source: www.geeksforgeeks.org

Tags: database insert javascript row sql

Link to this answer
Share Copy Link

Contributed on Jan 11 2022

Breakable Beetle

0 Answers Avg Quality 2/10

insert multiple Row in SQL database with NodeJS

Contents

More Related Answers

insert multiple Row in SQL database with NodeJS

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.