mysql - 如何在nodejs node-mysql中关闭与MYSQL的连接

Question

好像有时候连接MYSQL not closed成功了。我正在使用 nodejs 和 node-mysql 库。

client = mysql.createClient({ user: 'root', password: 'pass' });
client.query('USE db');
client.query( 'SELECT a FROM b ORDER BY c ASC', function selectCb(err, results, fields) {
  client.end();
  if (err) throw err;
  ....       
});

Answer 1

希望对您有所帮助!

client.end(function(err) {
    // do what you want after the connection if closed :)
});

您也可以查看此链接:https://github.com/felixge/node-mysql#pooling-connections `