How do I do a bulk insert in mySQL using node.js

by

Bulk inserts are possible by using nested array, see the github page

Nested arrays are turned into grouped lists (for bulk inserts), e.g.
[['a', 'b'], ['c', 'd']] turns into ('a', 'b'), ('c', 'd')

You just insert a nested array of elements.

An example is given in here

var mysql = require('mysql');
var conn = mysql.createConnection({
    ...
});

var sql = "INSERT INTO Test (name, email, n) VALUES ?";
var values = [
    ['demian', '[email protected]', 1],
    ['john', '[email protected]', 2],
    ['mark', '[email protected]', 3],
    ['pete', '[email protected]', 4]
];
conn.query(sql, [values], function(err) {
    if (err) throw err;
    conn.end();
});

Note: values is an array of arrays wrapped in an array

[ [ [...], [...], [...] ] ]

There is also a totally different node-msql package for bulk insertion

More Related Contents:

  1. How can i write in NodeJS with MongoDB the following MySQL Select?
  2. MySQL 8.0 – Client does not support authentication protocol requested by server; consider upgrading MySQL client
  3. MySQL with Node.js
  4. node-mysql multiple statements in one query
  5. nodejs mysql Error: Connection lost The server closed the connection
  6. Node.js can’t authenticate to MySQL 8.0
  7. node.js mysql error: ECONNREFUSED
  8. How to auto generate migrations with Sequelize CLI from Sequelize models?
  9. How to access a RowDataPacket object
  10. Retrieve last inserted id with Mysql
  11. How to pass parameters to mysql query callback in nodejs
  12. Making changes to multiple records based on change of single record with SQL
  13. node.js + mysql connection pooling
  14. connect ECONNREFUSED – node js , sql
  15. How to make join queries using Sequelize on Node.js
  16. NodeJS MySQL Dump
  17. Node.js connect to MySQL Docker container ECONNREFUSED
  18. Use promise to process MySQL return value in node.js
  19. NodeJS responded MySQL timezone is different when I fetch directly from MySQL
  20. Error in MySQL library for Node.js
  21. Which ORM should I use for Node.js and MySQL? [closed]
  22. find number of rows in returned mysql result (nodejs)
  23. MySQL giving “read ECONNRESET” error after idle time on node.js server
  24. Counting associated entries with Sequelize
  25. INSERT INTO fails with node-mysql
  26. Delete the entire content of all table in a Database [closed]
  27. MyISAM versus InnoDB [closed]
  28. How to count all rows when using SELECT with LIMIT in MySQL query?
  29. MySQL LOAD_FILE() loads null values
  30. How to sort a MYSQL table in a permanent way?

Leave a Comment