【转】Nodejs链接Mysql批量添加 insert into

 

const mysql = require('mysql')

var connection = mysql.createConnection({     
  host     : 127.0.0.1,       
  user     : 'root',              
  password : 'root',       
  port: '3306',                   
  database: '数据库名称', 
  //multipleStatements: true //返回的值为key/value
}); 

//批量添加
var  userAddSql = 'INSERT INTO t_test_oracle(Name,Age) VALUES ? ';  //最后是"?"  不是 "（?,?）"

//参数
var param = [['xiaohong',8],['xiaolan',12]]

//执行sql   第二个参数要加"[]"
var query = connection.query(userAddSql,[param],function (err, result) {
        if(err){
          console.log('[INSERT ERROR] - ',err.message);
          return;
        }        
       console.log('--------------------------INSERT----------------------------');
       console.log('INSERT ID:',result);        
       console.log('-----------------------------------------------------------------\n\n');  
});
console.log(query.sql);

//关闭链接
connection.end();