nodejs mysql嵌套查询_nodejs mysql查询结果到[对象对象]

我有这个密码:

var sql1 = "SELECT DISTINCT sensor_id, timestamp FROM Displacement_Record WHERE wave_type = 1 ORDER BY timestamp ASC";

var sql2 = "SELECT timestamp FROM Displacement_Record WHERE wave_type = 0 AND sensor_id = ?";

var sql3 = "SELECT latitude, longitude FROM Sensor_Record WHERE sensor_id = ?";

var pTime, sTime;

db.getConnection((err, conn) => {

if (err) throw err;

conn.query(sql1, function (err, res, fields) {

if (err) throw err;

for (i = 0; i < res.length; i++) {

var sensor = res[i].sensor_id;

console.log(sensor);

var pTime = res[i].timestamp;

sql2 = mysql.format(sql2, sensor);

conn.query(sql2, function (err, results, fields) {

if (err) throw err;

var sTime = res[i].timestamp; //timestamp error

console.log("results = " + results + " " + results.length);

conn.query(sql3, function (err, res, fields) {

if (err) throw err;

var location = [res[i].latitude, res[i].longitude];

console.log("Data = " + sensor + " " + pTime + " " + sTime + " " + latitude + " " + longitude);

});

});

}

});

conn.release();

});

第一个查询正确地给出了结果。我能得到并存储我需要的数据。但是,第二个和第三个查询的结果是:

results = [object Object],[object Object],[object Object]

投掷:

throw err; // Rethrow non-MySQL errors

^

TypeError: Cannot read property 'timestamp' of undefined

我想知道是什么原因。只有删除查询中的条件,才能得到正确的结果。不过,我当然需要这个条件。我还想知道,当我能够获得第一个查询的结果时,它为什么会在下面的查询中抛出错误,包括条件和全部。

我希望有人能帮助我,谢谢!