利用JSON.stringify()把对象转为对象字符串,可去掉RowDataPacket。
var mysql = require('mysql');
var connection = mysql.createConnection({
host : 'localhost',
user : 'root',
password : ***,
database : 'dbtest'
});
connection.connect();
connection.query('SELECT * FROM tabletpl', function (error, results, fields) {
if (error) throw error;
console.log(results);//[RowDataPacket {count:'1',type:'RangeError'},RowDataPacket{count:'3',type:'ReferenceError'}]
results = JSON.stringify(results);//把results对象转为字符串,去掉RowDataPacket
console.log(results);//'[{"count":"1","type":"RangeError"},{"count":"3","type":"ReferenceError"}]'
results = JSON.parse(results);//把results字符串转为json对象
});