mysql - 在promise-mysql中记录SQL执行的查询

Question

如 mysql 中所定义

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'

我们可以在日志中看到执行的查询请建议如何在promise-mysql中记录执行的查询

谢谢

Answer 1

此问题与 GITHUB issue 有关

来自 Github:

I'm not sure if this is helpful but you can set debug: ['ComQueryPacket', 'RowDataPacket'] when you create the connection to debug all queries.

希望这有帮助。