python - 如何在python中增加查询值？

Question

self.mycursor = self.mydb.cursor()
self.sql1 = "UPDATE counter SET count = %s WHERE id = %s"
self.val1 = (str(int('count' + 1)), '1')
self.mycursor.execute(self.sql1, self.val1)
self.mydb.commit()

在这部分代码中，我想增加查询值

Answer 1

如果您想为给定的 id 将计数器加 1，您可以执行以下操作:

self.sql1 = "UPDATE counter SET count = count + 1 WHERE id = %s"
self.val1 = (1)
self.mycursor.execute(self.sql1, self.val1)