/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 vote217 views1 answer
Upload file on node js azure function
Javascript Node.js
1 vote226 views1 answer
Node js sublime text
Javascript Node.js
0 vote218 views1 answer
Nodejs binary string to decimal number
Javascript Node.js
0 vote208 views1 answer
Load Balance 4 instances of api.js node js
Javascript Node.js
19 votes220 views3 answers
Node read file sync
Javascript Node.js
2 votes204 views1 answer
Node buffer size
Javascript Node.js
0 vote214 views2 answers
: not foundram Files/nodejs/npm: 3: : not foundram Files/nodejs/npm: 5:
Javascript Node.js
14 votes220 views4 answers
Node app
Javascript Node.js
47 votes206 views1 answer
Nodejs extract pdf data
Javascript Node.js
0 vote198 views1 answer
Check if string contains word nodejs
Javascript Node.js