mysql - Node.js mysql 推送回调

Question

   mysql.query('SELECT accountID,deviceID FROM EventData WHERE accountID = "'
       + acc
       + '" AND deviceID = "'
       + deviceID
       + '"  ORDER BY timestamp DESC LIMIT 1 ',
           function(err,rows,fields) {                   
               if (rows.length > 0) {                 
                   var accountID = rows[0].accountID;
                   var deviceID = rows[0].deviceID;
                   var re2 = ({
                       title: deviceID,                    
                   });                      
                   console.log(re2)
                   console.log("aaa")     
           }
    );

上面的代码产生以下输出:

   [{ title: 'dev1'}]
   aaa
   [{ title: 'dev2'}]
   aaa

但我希望看到以下内容:

   [{ title: 'dev1'},
   { title: 'dev2'}]
   aaa

我做错了什么？

Answer 1

您甚至没有遍历行，只是将第一个标题添加到 re2。

这段代码应该可以工作:

mysql.query('SELECT accountID,deviceID FROM EventData WHERE accountID = ? AND deviceID = ? ORDER BY timestamp DESC LIMIT 1', [acc, deviceID],
       function(err,rows,fields) {
           if (rows.length > 0) { 
               var re2 = [ ];                    
               for (var i = 0; i < rows.length; i++) {
                   re2.push({ title: rows[i].deviceID });
               }                    
               console.log(re2);
               console.log("aaa")  ;
           }   
       }
);

请注意，我使用占位符传递参数，而不是将它们显式连接到字符串。