模块化SQL WHERE语句

Question

我正在尝试在具有模块化输入的python脚本中创建准备好的SQL语句。语句的“插入”部分工作正常，但无法让WHERE子句模块化地更新。有办法这样做吗？

query = "INSERT INTO MachineInfo ( Description, Location, IP, License )
         WHERE id = ID
         VALUES (?,?,?,?,?)"


#The arguments are all predefined variables
args = [ deviceName, deviceLocation, ipAddress, license, ID ]

system.db.runPrepUpdate( query, args )

Answer 1

你好像想要一个UPDATE

UPDATE MachineInfo 
    SET Description = ?,
        Location = ?,
        IP = ?,
        License = ?
    WHERE id = ?;