mysql - 在 nodejs 中终止回调

Question

我是 nodejs 的新手。我正在使用 mysql Node 模块。这是我使用它的方式:

var connection = mysql.createConnection({
    host: 'localhost',
    user: 'root',
    password: '',
    database: 'sample'
});

connection.connect(function (err) {
    if (!err) {
        console.log("Database is connected ... \n\n");
    } else {
        console.log("Error connecting database ... \n\n");
    }
});

var post  = {PersonID: 1, Name: 'Prachi', City: 'Blore'};
var query = connection.query('INSERT INTO Persons SET ?', post, function(error, result) {
    if (error) {
        console.log(error.message);
    } else {
        console.log('success');
    }
});
console.log(query.sql);

此 Node 代码正常运行。如中，它将数据添加到表中。但它不会终止。我犯了什么错误？

Answer 1

仔细看官方文档，要关闭连接:

var mysql      = require('mysql');
var connection = mysql.createConnection({
  host     : 'localhost',
  user     : 'me',
  password : 'secret'
});

connection.connect();

connection.query('SELECT 1 + 1 AS solution', function(err, rows, fields) {
  if (err) throw err;

  console.log('The solution is: ', rows[0].solution);
});

connection.end();