我如何使用node.js在MySQL中进行批量插入 [英] How do I do a bulk insert in mySQL using node.js

问题描述

如果使用类似的方法，如何将大量插入MySQL https://github.com/felixge/node-mysql

How would one do a bulk insert into mySQL if using something like https://github.com/felixge/node-mysql

推荐答案

使用嵌套数组可以批量插入，请参见

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

嵌套数组变成分组列表(用于批量插入)，例如 [['a', 'b'], ['c', 'd']]变成('a', 'b'), ('c', 'd')

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.

在此处

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

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

注意:values是包裹在数组中的数组数组

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

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

对于批量插入，还有一个完全不同的 node-msql 包

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

这篇关于我如何使用node.js在MySQL中进行批量插入的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！