mysql - MySql & Node.js - 更新多行和多列

Question

我正在使用 node.js 和 Mysql，我想根据 id 更新我的数据库行和列。我创建了以下函数，但我不断收到错误：

module.exports.editNetworks= async (editedNetworks)=>{
    return new Promise(async function (resolve, reject) {
    var networksToEdit=[];
    var networkObj={};
    for(let network of editedNetworks)
    {
            networkObj={
                id:network.id,
                product_Id:network.product_Id,
                domain_Name:network.domain_Name,
                publisher_Id:network.publisher_Id,
                relationship:network.relationship,
                certification_Id:network.certification_Id,
                lastUpdate:network.lastUpdate, //Needs to convert it to global time zone for every time zone.
            }
            networksToEdit.push(networkObj);
    }
    let netWorkQuery='';
    for(let i in editedNetworks)
    {
        netWorkQuery+=`UPDATE networks SET `
        netWorkQuery+=`domain_Name='${editedNetworks[i].domain_Name}', `
        netWorkQuery+=`publisher_Id='${editedNetworks[i].publisher_Id}', `
        netWorkQuery+=`relationship='${editedNetworks[i].relationship}', `
        netWorkQuery+=`certification_Id='${editedNetworks[i].certification_Id}', `
        netWorkQuery+=`lastUpdate='${editedNetworks[i].lastUpdate}' `
        netWorkQuery+=`WHERE id=${editedNetworks[i].id}; `
    }
    console.log('-------------------------------',netWorkQuery)
    con.query(netWorkQuery, function(err,result,fields){
        if (err)
        {
            console.log('there is an error: ',err);
            throw err;  
        }
        resolve(result);
    })
})
}

你能告诉我我在这里做错了什么吗？

谢谢 ：）

标签： mysqlsqlnode.js

Answer 1

lastupdate 值应由单个 qoutes 包围。