javascript - Node js mysql 语法错误

Question

我在服务器端的 Node js 中编写了一些代码来更新 MySQL 数据库。

这是我的代码:

exports.addPlayerToMatch = function(uid,matchId){
    return new Promise(function(resolve,reject){
        dbFunctions.getPlayerUids(matchId).then(function(rows){
            playerUids = JSON.parse(rows[0].uids_of_players);
            playerUids.push(uid);
            console.log("new player uids: " +playerUids);
            numberOfPlayers = playerUids.length;
            db.query('UPDATE current_matches SET number_of_players = ?, 
uids_of_players = ? WHERE id = ?' ,[numberOfPlayers,playerUids,matchId], 
function (err, rows) {
                if (err){ console.log("ErrorForAddPlayerToMatch: "+err);}
            });
            resolve(numberOfPlayers);
        }); 
    }); 
};

这是错误:

ErrorForAddPlayerToMatch: Error: ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''3d8b7210fc1999bf191b0e1f7d744269' WHERE id = 29' at line 1

我不知道!!

请帮忙。

Answer 1

问题是我忘记在查询中使用数组之前再次将其转换为 JSON 对象。

它会解决这样的问题:

var playerUids = JSON.stringify(playerUids);

然后在查询中使用它。