How do I do a bulk insert in MySQL using Node.js

weixin_34008784

于 2016-03-22 16:49:00 发布

阅读量71

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/vjianwang/p/builk_insert_mysql_nodejs.html

版权

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({
　　host: 'localhost',
　　user: 'username',
　　password: 'password',
　　database: 'mydatabase'
});
conn.connect();
var sql = "INSERT INTO Test (name, email, n) VALUES ?";
var values = [
    ['demian', 'demian@gmail.com', 1],
    ['john', 'john@gmail.com', 2],
    ['mark', 'mark@gmail.com', 3],
    ['pete', 'pete@gmail.com', 4]
];
conn.query(sql, [values], function(err) {
    if (err) throw err;
    conn.end();
});