var leftTickets = 1;
pool.getConnection(function(err, connection) {
connection.query($sql.selectLeft, no, function(err, result) {
leftTickets = result[0].leftTickets - 1;
console.log('ss:'+leftTickets);
});
connection.query('update info set leftTickets=? where no=?', [leftTickets,no], function(err, result) {
console.log('ssss:'+leftTickets);
});
});
leftTickets数据库里本来是66,做了减法,两处console.log结果都是65.但是写到数据库里的竟然是1,这个1想必是初始的1,这是为什么呢。我要如何解决这一问题呢?