/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 vote149 views1 answer
Node js check if a user exists in mysql
Javascript Node.js
0 vote113 views1 answer
Configuration file must specify a supported nodejs10 version that is compatible with the runtime specified in the deployment.
Javascript Node.js
2 votes150 views1 answer
Node print stdin
Javascript Node.js
0 vote145 views1 answer
Employee salary calculate in node
Javascript Node.js
20 votes162 views2 answers
Node js quit
Javascript Node.js
0 vote152 views1 answer
Node js url download
Javascript Node.js
1 vote145 views2 answers
Nodejs express server img src
Javascript Node.js
2 votes144 views2 answers
Send multipart form data axios with node js
Javascript Node.js
4 votes136 views1 answer
Get ip of user in node js
Javascript Node.js
25 votes164 views3 answers
Nodejs file exists
Javascript Node.js