mysql+node.js连接基本操作

在这里贴一下官方的文档，写的很清楚了
点击这里跳转

连接操作

//引用mysql模块
var mysql=require('mysql');
//设置连接的host，user，password，也可根据自己需要进行添加其他参数
var connection=mysql.createConnection({
  host:'localhost',
  user:'root',
  password:'123456'
});
//连接并且判断是否成功
connection.connect(function(err){
  if(err){
    console.err('error connecting'+err.stack);
    return;
  }
  console.log('connected as id'+connection.threadId);
})

结束连接
有两种方式

connection.end(function(err) {
  // The connection is terminated now
});

connection.destroy();

关于两种结束的方式
官方是这样解释的
end():
This will make sure all previously enqueued queries are still before sending a COM_QUIT packet to the MySQL server. If a fatal error occurs before the COM_QUIT packet can be sent, an err argument will be provided to the callback, but the connection will be terminated regardless of that.
destory():
This will cause an immediate termination of the underlying socket. Additionally destroy() guarantees that no more events or callbacks will be triggered for the connection.
大概就是，end()在结束前会将之前排队的查询执行结束后再结束
但是destroy()会直接强制结束。