node mysql 查询错误,Node.js / MySQL：在node.js的错误日志中打印实际查询

I have some Node.js code that tries to update a database in something like the following:

connection.query(command, function(err,rows) {

if (err){

console.log(command);

console.log("ERROR");

console.log(err);

return;

}

console.log("good");

});

The above is run repeatedly for different values of "command", thus generating different queries to the database. The problem is that when there is an error, the wrong query gets printed in the console.log(command). This is because the time the query is added to the queue, and the time the query is actually executed are not the same, so the value of "command" at each of these times isn't the same. Is there a way around this?

Note: console.log(err) prints the error itself, and also part of the query, but it only prints the line where the error occurred. I want to print the whole query.

解决方案

As per docs, You can use query.sql to get the actual executed query.

var post = {id: 1, title: 'Hello MySQL'};

var query = connection.query('INSERT INTO posts SET ?', post, function(err, result) {

// Neat!

});

console.log(query.sql); // INSERT INTO posts SET `id` = 1, `title` = 'Hello MySQL'

In this case, it will be

connection.query(command, function (err, rows) {

if (err) {

console.log('this.sql', this.sql); //command/query

console.log(command);

console.log("ERROR");

console.log(err);

return;

}

console.log("good");

});