mysql - Node JS mysql 为数据库中的 1 列返回错误值

Question

我正在尝试使用 MYSQL 库从 Node JS 中的数据库中获取一些记录，但我得到的列 pid 值错误。对于所有记录，它每次都会返回 76561198056610560，即使该列的值是其他值也是如此。

这是我的表格的样子:

did int(10) unsigned        NO  PRI NULL    auto_increment
pid bigint(20) unsigned     NO  MUL NULL    
oid int(10) unsigned        NO      NULL    
secretcode  varchar(255)    NO      NULL    
reward  int(10) unsigned    NO      NULL    
status  tinyint(1)          NO      NULL    
offersent   tinyint(1)      NO      NULL    
created_at  timestamp       NO      CURRENT_TIMESTAMP   on update     CURRENT_TIMESTAMP
updated_at  timestamp       NO      0000-00-00 00:00:00 

表格内容:

1   76561198056610558   0   @JAMIE@SECRET1  100 0   0   2016-01-21 10:09:30 0000-00-00 00:00:00
2   76561198056610560   0   @JAMIE@SECRET2  100 0   0   2016-01-21 10:09:32 0000-00-00 00:00:00
3   76561198056610562   0   @JAMIE@SECRET3  100 0   0   2016-01-21 10:09:35 0000-00-00 00:00:00

我的代码:

connection.query('SELECT * from deposit WHERE offersent = 0;', function(err, rows, fields) {
    if (!err){
        for (var i in rows) {
            logger.debug(rows[i])
            logger.info(rows[i].pid);
        }
    }else{
        logger.debug('SQL Error: '+ err);
    }
});

输出

debug:  did=1, pid=76561198056610560, oid=0, secretcode=@JAMIE@SECRET1, reward=100, status=0, offersent=0, created_at=Thu Jan 21 2016 10:09:30 GMT+0100 (CET), updated_at=0000-00-00 00:00:00
info: 76561198056610560

debug:  did=2, pid=76561198056610560, oid=0, secretcode=@JAMIE@SECRET2, reward=100, status=0, offersent=0, created_at=Thu Jan 21 2016 10:09:32 GMT+0100 (CET), updated_at=0000-00-00 00:00:00
info: 76561198056610560

debug:  did=3, pid=76561198056610560, oid=0, secretcode=@JAMIE@SECRET3, reward=100, status=0, offersent=0, created_at=Thu Jan 21 2016 10:09:35 GMT+0100 (CET), updated_at=0000-00-00 00:00:00
info: 76561198056610560

Answer 1

在您的连接选项中添加另一个字段

supportBigNumbers: True

也许可以。

引用:https://github.com/felixge/node-mysql#connection-options