blocks|key|461433|text|@Ragnar123答案是正确的，但我看到很多人在评论中说它不起作用。我也遇到了同样的问题，看起来你需要像这样用[]包装你的数组：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|461434|var+pars+=+[
++++[99,+"1984-11-20",+1.1,+2.2,+200],+
++++[98,+"1984-11-20",+1.1,+2.2,+200],+
++++[97,+"1984-11-20",+1.1,+2.2,+200]
];|code-block|syntax|javascript|461435|它需要像[pars]一样传递到方法中。|461436|entityMap^0|1K|2|0|0|4|6|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|R|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|S|8|@$9|T|A|U|B|C]]|D|@]|E|$]]|$1|M|3|-4|5|6|7|V|8|@]|D|@]|E|$]]]|N|$]]

@Ragnar123 answer is correct, but I see a lot of people saying in the comments that it is not working. I had the same problem and it seems like you need to wrap your array in <code>[]</code> like this:

<pre><code>var pars = [
 [99, "1984-11-20", 1.1, 2.2, 200], 
 [98, "1984-11-20", 1.1, 2.2, 200], 
 [97, "1984-11-20", 1.1, 2.2, 200]
];
</code></pre>

It needs to be passed like <code>[pars]</code> into the method.

blocks|key|676820|text|我今天遇到了这个(mysql+2.16.0)，我想我应该分享我的解决方案：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|676821|const+items+=+[
++++{name:+'alpha',+description:+'describes+alpha',+value:+1},
++++...
];

db.query(
++++'INSERT+INTO+my_table+(name,+description,+value)+VALUES+?',
++++[items.map(item+=>+[item.name,+item.description,+item.value])],
++++(error,+results)+=>+{...}
);|code-block|syntax|javascript|676822|entityMap|0|LINK|mutability|MUTABLE|url|https://www.npmjs.com/package/mysql^0|9|5|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@$A|R|B|S|1|T]]|C|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|C|$G|H]]|$1|I|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|J|$K|$5|L|M|N|C|$O|P]]]]

I ran into this today (<a href="https://www.npmjs.com/package/mysql" rel="noreferrer">mysql</a> 2.16.0) and thought I'd share my solution: 

<pre><code>const items = [
 {name: 'alpha', description: 'describes alpha', value: 1},
 ...
];

db.query(
 'INSERT INTO my_table (name, description, value) VALUES ?',
 [items.map(item =&gt; [item.name, item.description, item.value])],
 (error, results) =&gt; {...}
);
</code></pre>

blocks|key|461588|text|我四处寻找关于批量插入对象的答案。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|461589|根据Ragnar123的回答，我创建了这个函数：|461590|function+bulkInsert(connection,+table,+objectArray,+callback)+{
++let+keys+=+Object.keys(objectArray[0]);
++let+values+=+objectArray.map(+obj+=>+keys.map(+key+=>+obj[key]));
++let+sql+=+'INSERT+INTO+'+%2B+table+%2B+'+('+%2B+keys.join(',')+%2B+')+VALUES+?';
++connection.query(sql,+[values],+function+(error,+results,+fields)+{
++++if+(error)+callback(error);
++++callback(null,+results);
++});
}

bulkInsert(connection,+'my_table_of_objects',+objectArray,+(error,+response)+=>+{
++if+(error)+res.send(error);
++res.json(response);
});|code-block|syntax|javascript|461591|希望它能帮上忙！|461592|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|O|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

I was looking around for an answer on bulk inserting Objects.

The answer by Ragnar123 led me to making this function:

<pre><code>function bulkInsert(connection, table, objectArray, callback) {
 let keys = Object.keys(objectArray[0]);
 let values = objectArray.map( obj =&gt; keys.map( key =&gt; obj[key]));
 let sql = 'INSERT INTO ' + table + ' (' + keys.join(',') + ') VALUES ?';
 connection.query(sql, [values], function (error, results, fields) {
 if (error) callback(error);
 callback(null, results);
 });
}

bulkInsert(connection, 'my_table_of_objects', objectArray, (error, response) =&gt; {
 if (error) res.send(error);
 res.json(response);
});
</code></pre>

Hope it helps!

blocks|key|676554|text|所有的道具都给了Ragnar123他的答案。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|676555|我只是想在Josh+Harington提出的关于插入的ID的问题之后进行扩展。|676556|这些将是连续的。请看这个答案：Does+a+MySQL+multi-row+insert+grab+sequential+autoincrement+IDs?|offset|length|676557|因此，您可以这样做(请注意我对result.insertId做了什么)：|676558|++var+statement+=+'INSERT+INTO+??+('+%2B+sKeys.join()+%2B+')+VALUES+?';
++var+insertStatement+=+[tableName,+values];
++var+sql+=+db.connection.format(statement,+insertStatement);
++db.connection.query(sql,+function(err,+result)+{
++++if+(err)+{
++++++return+clb(err);
++++}
++++var+rowIds+=+[];
++++for+(var+i+=+result.insertId;+i+<+result.insertId+%2B+result.affectedRows;+i%2B%2B)+{
++++++rowIds.push(i);
++++}
++++for+(var+i+in+persistentObjects)+{
++++++var+persistentObject+=+persistentObjects[i];
++++++persistentObject[persistentObject.idAttributeName()]+=+rowIds[i];
++++}
++++clb(null,+persistentObjects);
++});|code-block|syntax|javascript|676559|(我从名为persistentObjects的对象数组中提取了值。)|676560|希望这能有所帮助。|676561|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/8481421/does-a-mysql-multi-row-insert-grab-sequential-autoincrement-ids^0|0|0|F|1S|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|11|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|12|8|@]|9|@$F|13|G|14|1|15]]|A|$]]|$1|H|3|I|5|6|7|16|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|17|8|@]|9|@]|A|$M|N]]|$1|O|3|P|5|6|7|18|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|19|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|1A|8|@]|9|@]|A|$]]]|T|$U|$5|V|W|X|A|$Y|Z]]]]

All props to Ragnar123 for his answer.

I just wanted to expand it after the question asked by Josh Harington to talk about inserted IDs.

These will be sequential. See this answer : <a href="https://stackoverflow.com/questions/8481421/does-a-mysql-multi-row-insert-grab-sequential-autoincrement-ids">Does a MySQL multi-row insert grab sequential autoincrement IDs?</a>

Hence you can just do this (notice what I did with the result.insertId):

<pre><code> var statement = 'INSERT INTO ?? (' + sKeys.join() + ') VALUES ?';
 var insertStatement = [tableName, values];
 var sql = db.connection.format(statement, insertStatement);
 db.connection.query(sql, function(err, result) {
 if (err) {
 return clb(err);
 }
 var rowIds = [];
 for (var i = result.insertId; i &lt; result.insertId + result.affectedRows; i++) {
 rowIds.push(i);
 }
 for (var i in persistentObjects) {
 var persistentObject = persistentObjects[i];
 persistentObject[persistentObject.idAttributeName()] = rowIds[i];
 }
 clb(null, persistentObjects);
 });
</code></pre>

(I pulled the values from an array of objects that I called persistentObjects.)

Hope this helps.

blocks|key|676935|text|这是一个快速的“原始-复制-粘贴”过程，在node.js+>=+11的mysql中用来推送文件列。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|676936|在几秒钟内完成250k行|676937|'use+strict';

const+mysql+=+require('promise-mysql');
const+fs+=+require('fs');
const+readline+=+require('readline');

async+function+run()+{
++const+connection+=+await+mysql.createConnection({
++++host:+'1.2.3.4',
++++port:+3306,
++++user:+'my-user',
++++password:+'my-psw',
++++database:+'my-db',
++});

++const+rl+=+readline.createInterface({+input:+fs.createReadStream('myfile.txt')+});

++let+total+=+0;
++let+buff+=+[];
++for+await+(const+line+of+rl)+{
++++buff.push([line]);
++++total%2B%2B;
++++if+(buff.length+%25+2000+===+0)+{
++++++await+connection.query('INSERT+INTO+Phone+(Number)+VALUES+?',+[buff]);
++++++console.log(total);
++++++buff+=+[];
++++}
++}

++if+(buff.length+>+0)+{
++++await+connection.query('INSERT+INTO+Phone+(Number)+VALUES+?',+[buff]);
++++console.log(total);
++}

++console.log('end');
++connection.close();
}

run().catch(console.log);|code-block|syntax|javascript|676938|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

This is a fast "raw-copy-paste" snipped to push a file column in mysql with node.js >= 11

250k row in few seconds

<pre><code>'use strict';

const mysql = require('promise-mysql');
const fs = require('fs');
const readline = require('readline');

async function run() {
 const connection = await mysql.createConnection({
 host: '1.2.3.4',
 port: 3306,
 user: 'my-user',
 password: 'my-psw',
 database: 'my-db',
 });

 const rl = readline.createInterface({ input: fs.createReadStream('myfile.txt') });

 let total = 0;
 let buff = [];
 for await (const line of rl) {
 buff.push([line]);
 total++;
 if (buff.length % 2000 === 0) {
 await connection.query('INSERT INTO Phone (Number) VALUES ?', [buff]);
 console.log(total);
 buff = [];
 }
 }

 if (buff.length &gt; 0) {
 await connection.query('INSERT INTO Phone (Number) VALUES ?', [buff]);
 console.log(total);
 }

 console.log('end');
 connection.close();
}

run().catch(console.log);
</code></pre>

blocks|key|461381|text|如果这里需要是我们解决数组插入的方法|type|unstyled|depth|inlineStyleRanges|entityRanges|data|461382|请求来自邮递员(你会看到“客人”)|461383|+{
++"author_id"+:+3,
++"name"+:+"World+War+II",
++"date"+:+"01+09+1939",+
++"time"+:+"16+:+22",
++"location"+:+"39.9333635/32.8597419",
++"guests"+:+[2,+3,+1337,+1942,+1453]
}|code-block|syntax|javascript|461384|以及我们如何编写脚本|461385|var+express+=+require('express');
var+utils+=+require('./custom_utils.js');

module.exports+=+function(database){
++++var+router+=+express.Router();

++++router.post('/',+function(req,+res,+next)+{
++++++++database.query('INSERT+INTO+activity+(author_id,+name,+date,+time,+location)+VALUES+(?,+?,+?,+?,+?)+ON+DUPLICATE+KEY+UPDATE+name+=+VALUES(name),+date+=+VALUES(date),+time+=+VALUES(time),+location+=+VALUES(location)',+
++++++++++++++++[req.body.author_id,+req.body.name,+req.body.date,+req.body.time,+req.body.location],+function(err,+results,+fields){
++++++++++++if(err){
++++++++++++++++console.log(err);
++++++++++++++++res.json({+status:+utils.respondMSG.DB_ERROR+});
++++++++++++}
++++++++++++else+{
++++++++++++++++var+act_id+=+results.insertId;
++++++++++++++++database.query('INSERT+INTO+act_guest+(user_id,+activity_id,+status)+VALUES+?+ON+DUPLICATE+KEY+UPDATE+status+=+VALUES(status)',+
++++++++++++++++++++++++[Array.from(req.body.guests).map(function(g){+return+[g,+act_id,+0];+})],+function(err,+results,+fields){
++++++++++++++++++++if(err){
++++++++++++++++++++++++console.log(err);
++++++++++++++++++++++++res.json({+status:+utils.respondMSG.DB_ERROR+});
++++++++++++++++++++}
++++++++++++++++++++else+{
++++++++++++++++++++++++res.json({+
++++++++++++++++++++++++++++status:+utils.respondMSG.SUCCEED,
++++++++++++++++++++++++++++data:+{
++++++++++++++++++++++++++++++++activity_id+:+act_id
++++++++++++++++++++++++++++}
++++++++++++++++++++++++});
++++++++++++++++++++}
++++++++++++++++});
++++++++++++}
++++++++});
++++});
++++return+router;
};|461386|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Q|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

In case that needed here is how we solved insert of array

request is from postman (You will look at "guests" )

<pre><code> {
 "author_id" : 3,
 "name" : "World War II",
 "date" : "01 09 1939", 
 "time" : "16 : 22",
 "location" : "39.9333635/32.8597419",
 "guests" : [2, 3, 1337, 1942, 1453]
}
</code></pre>

And how we scripted

<pre><code>var express = require('express');
var utils = require('./custom_utils.js');

module.exports = function(database){
 var router = express.Router();

 router.post('/', function(req, res, next) {
 database.query('INSERT INTO activity (author_id, name, date, time, location) VALUES (?, ?, ?, ?, ?) ON DUPLICATE KEY UPDATE name = VALUES(name), date = VALUES(date), time = VALUES(time), location = VALUES(location)', 
 [req.body.author_id, req.body.name, req.body.date, req.body.time, req.body.location], function(err, results, fields){
 if(err){
 console.log(err);
 res.json({ status: utils.respondMSG.DB_ERROR });
 }
 else {
 var act_id = results.insertId;
 database.query('INSERT INTO act_guest (user_id, activity_id, status) VALUES ? ON DUPLICATE KEY UPDATE status = VALUES(status)', 
 [Array.from(req.body.guests).map(function(g){ return [g, act_id, 0]; })], function(err, results, fields){
 if(err){
 console.log(err);
 res.json({ status: utils.respondMSG.DB_ERROR });
 }
 else {
 res.json({ 
 status: utils.respondMSG.SUCCEED,
 data: {
 activity_id : act_id
 }
 });
 }
 });
 }
 });
 });
 return router;
};
</code></pre>

blocks|key|676896|text|我想提的几件事是，我正在使用mysql包与我的数据库建立连接，您在下面看到的是为插入批量查询而编写的工作代码。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|676897|const+values+=+[
++[1,+'DEBUG',+'Something+went+wrong.+I+have+to+debug+this.'],
++[2,+'INFO',+'This+just+information+to+end+user.'],
++[3,+'WARNING',+'Warning+are+really+helping+users.'],
++[4,+'SUCCESS',+'If+everything+works+then+your+request+is+successful']
];

const+query+=+"INSERT+INTO+logs(id,+type,+desc)+VALUES+?";

const+query+=+connection.query(query,+[values],+function(err,+result)+{
++if+(err)+{
++++console.log('err',+err)
++}

++console.log('result',+result)
});|code-block|syntax|javascript|676898|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/mysqljs/mysql^0|E|5|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@$A|R|B|S|1|T]]|C|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|C|$G|H]]|$1|I|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|J|$K|$5|L|M|N|C|$O|P]]]]

Few things I want to mention is that I'm using <a href="https://github.com/mysqljs/mysql" rel="nofollow noreferrer">mysql</a> package for making a connection with my database and what you saw below is working code and written for insert bulk query.

<pre><code>const values = [
 [1, 'DEBUG', 'Something went wrong. I have to debug this.'],
 [2, 'INFO', 'This just information to end user.'],
 [3, 'WARNING', 'Warning are really helping users.'],
 [4, 'SUCCESS', 'If everything works then your request is successful']
];

const query = "INSERT INTO logs(id, type, desc) VALUES ?";

const query = connection.query(query, [values], function(err, result) {
 if (err) {
 console.log('err', err)
 }

 console.log('result', result)
});
</code></pre>

blocks|key|676974|text|可以使用下面的代码在Node.js中进行大容量插入。我已经参考了很多博客来获得这项工作。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|676975|请同时参考此链接。https://www.technicalkeeda.com/nodejs-tutorials/insert-multiple-records-into-mysql-using-nodejs|offset|length|676976|工作代码。|676977|++const+educations+=+request.body.educations;
++let+queryParams+=+[];
++for+(let+i+=+0;+i+<+educations.length;+i%2B%2B)+{
++++const+education+=+educations[i];
++++const+userId+=+education.user_id;
++++const+from+=+education.from;
++++const+to+=+education.to;
++++const+instituteName+=+education.institute_name;
++++const+city+=+education.city;
++++const+country+=+education.country;
++++const+certificateType+=+education.certificate_type;
++++const+studyField+=+education.study_field;
++++const+duration+=+education.duration;

++++let+param+=+[
++++++from,
++++++to,
++++++instituteName,
++++++city,
++++++country,
++++++certificateType,
++++++studyField,
++++++duration,
++++++userId,
++++];

++++queryParams.push(param);
++}

++let+sql+=
++++"insert+into+tbl_name+(education_from,+education_to,+education_institute_name,+education_city,+education_country,+education_certificate_type,+education_study_field,+education_duration,+user_id)+VALUES+?";
++let+sqlQuery+=+dbManager.query(sql,+[queryParams],+function+(
++++err,
++++results,
++++fields
++)+{
++++let+res;
++++if+(err)+{
++++++console.log(err);
++++++res+=+{
++++++++success:+false,
++++++++message:+"Insertion+failed!",
++++++};
++++}+else+{
++++++res+=+{
++++++++success:+true,
++++++++id:+results.insertId,
++++++++message:+"Successfully+inserted",
++++++};
++++}

++++response.send(res);
++});|code-block|syntax|javascript|676978|希望这能对你有所帮助。|676979|entityMap|0|LINK|mutability|MUTABLE|url|https://www.technicalkeeda.com/nodejs-tutorials/insert-multiple-records-into-mysql-using-nodejs^0|0|9|2N|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|X|8|@]|9|@$D|Y|E|Z|1|10]]|A|$]]|$1|F|3|G|5|6|7|11|8|@]|9|@]|A|$]]|$1|H|3|I|5|J|7|12|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|13|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|14|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|V]]]]

Bulk insert in Node.js can be done using the below code. I have referred lots of blog for getting this work.

please refer this link as well.
<a href="https://www.technicalkeeda.com/nodejs-tutorials/insert-multiple-records-into-mysql-using-nodejs" rel="nofollow noreferrer">https://www.technicalkeeda.com/nodejs-tutorials/insert-multiple-records-into-mysql-using-nodejs</a>

The working code.

<pre><code> const educations = request.body.educations;
 let queryParams = [];
 for (let i = 0; i &lt; educations.length; i++) {
 const education = educations[i];
 const userId = education.user_id;
 const from = education.from;
 const to = education.to;
 const instituteName = education.institute_name;
 const city = education.city;
 const country = education.country;
 const certificateType = education.certificate_type;
 const studyField = education.study_field;
 const duration = education.duration;

 let param = [
 from,
 to,
 instituteName,
 city,
 country,
 certificateType,
 studyField,
 duration,
 userId,
 ];

 queryParams.push(param);
 }

 let sql =
 "insert into tbl_name (education_from, education_to, education_institute_name, education_city, education_country, education_certificate_type, education_study_field, education_duration, user_id) VALUES ?";
 let sqlQuery = dbManager.query(sql, [queryParams], function (
 err,
 results,
 fields
 ) {
 let res;
 if (err) {
 console.log(err);
 res = {
 success: false,
 message: "Insertion failed!",
 };
 } else {
 res = {
 success: true,
 id: results.insertId,
 message: "Successfully inserted",
 };
 }

 response.send(res);
 });
</code></pre>

Hope this will help you.

blocks|key|461872|text|如果要插入对象，请使用以下命令：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|461873|++++currentLogs+=+[
+{+socket_id:+'Server',+message:+'Socketio+online',+data:+'Port++3333',+logged:+'2014-05-14+14:41:11'+},
+{+socket_id:+'Server',+message:+'Waiting+for+Pi+to+connect...',+data:+'Port:+8082',+logged:+'2014-05-14+14:41:11'+}
];

console.warn(currentLogs.map(logs=>[+logs.socket_id+,+logs.message+,+logs.data+,+logs.logged+]));|code-block|syntax|javascript|461874|输出将为：|461875|[
++[+'Server',+'Socketio+online',+'Port++3333',+'2014-05-14+14:41:11'+],
++[
++++'Server',
++++'Waiting+for+Pi+to+connect...',
++++'Port:+8082',
++++'2014-05-14+14:41:11'
++]
]|461876|另外，请查看documentation以了解更多有关map函数的信息。|offset|length|461877|entityMap|0|LINK|mutability|MUTABLE|url|https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Array/map^0|0|0|0|0|6|D|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Y|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|Z|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|10|8|@]|9|@$M|11|N|12|1|13]]|A|$]]|$1|O|3|-4|5|6|7|14|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|V]]]]

If you want to insert object, use this:
<pre><code> currentLogs = [
 { socket_id: 'Server', message: 'Socketio online', data: 'Port 3333', logged: '2014-05-14 14:41:11' },
 { socket_id: 'Server', message: 'Waiting for Pi to connect...', data: 'Port: 8082', logged: '2014-05-14 14:41:11' }
];

console.warn(currentLogs.map(logs=&gt;[ logs.socket_id , logs.message , logs.data , logs.logged ]));
</code></pre>
The output will be:
<pre><code>[
 [ 'Server', 'Socketio online', 'Port 3333', '2014-05-14 14:41:11' ],
 [
 'Server',
 'Waiting for Pi to connect...',
 'Port: 8082',
 '2014-05-14 14:41:11'
 ]
]
</code></pre>
Also, please check the <a href="https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Array/map" rel="nofollow noreferrer">documentation</a> to know more about the map function.

blocks|key|677024|text|Client.createClient+=+(clientReqData,+result)+=>{
var+command+=+'INSERT+INTO+client+(name,email,phone,country_code,city,state,address,salaes_account_manager,internal_notes)+VALUES+(?,?,?,?,?,?,?,?,?)'+;
dbConn.query(command,[clientReqData.name,
++++clientReqData.email,clientReqData.phone,clientReqData.country_code,clientReqData.city,clientReqData.state,clientReqData.address,clientReqData.salaes_account_manager,clientReqData.internal_notes],(err,res)=>{
++++if(err){
++++++++console.log(err)
++++}else+{
++++++++client_id+=+res.insertId;
++++++++var+command+=+'INSERT+INTO+client_contact_person+(name,+email+,phone,client_id)+VALUES+?';
++++++++dbConn.query(command,
++++++++++++[clientReqData.contact.map(item+=>+[item.name,+item.email,+item.phone,client_id])],
++++++++++++(err,+res)+=>+{
++++++++++++++++if(err)+throw+err
++++++++++++}
++++++++);
++++++++result(null,res);
++++}
})|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|677025|}|unstyled|677026|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|J|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|K|8|@]|9|@]|A|$]]]|H|$]]

<pre><code>Client.createClient = (clientReqData, result) =&gt;{
var command = 'INSERT INTO client (name,email,phone,country_code,city,state,address,salaes_account_manager,internal_notes) VALUES (?,?,?,?,?,?,?,?,?)' ;
dbConn.query(command,[clientReqData.name,
 clientReqData.email,clientReqData.phone,clientReqData.country_code,clientReqData.city,clientReqData.state,clientReqData.address,clientReqData.salaes_account_manager,clientReqData.internal_notes],(err,res)=&gt;{
 if(err){
 console.log(err)
 }else {
 client_id = res.insertId;
 var command = 'INSERT INTO client_contact_person (name, email ,phone,client_id) VALUES ?';
 dbConn.query(command,
 [clientReqData.contact.map(item =&gt; [item.name, item.email, item.phone,client_id])],
 (err, res) =&gt; {
 if(err) throw err
 }
 );
 result(null,res);
 }
})
</code></pre>
}

How would one do a bulk insert into mySQL if using something like 
<a href="https://github.com/felixge/node-mysql" rel="noreferrer">https://github.com/felixge/node-mysql</a>

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

数据库

如果使用像这样的东西，如何在mySQL中进行大容量插入

问如何使用node.js在mySQL中执行大容量插入
EN

回答 10

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何使用node.js在mySQL中执行大容量插入EN

回答 10

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何使用node.js在mySQL中执行大容量插入
EN