我是python新手,我想更新数据库中计数为0的每条记录。我试了很多都找不到帮助。
for row in cur.fetchall():
if row[3] == 0:
cur.execute("UPDATE tble SET count = 1 WHERE name = %s" %row[1])
最佳答案
假设您的表具有此结构:
CREATE TABLE `test` (
`sno` int(11) NOT NULL,
`name` varchar(50) NOT NULL,
`count` int(11) NOT NULL,
`dtCreated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
);
下面是简单的代码-
import pymysql
conn = pymysql.connect(host='localhost', unix_socket='', user='USER', passwd='PASSWORD', db='DATABASENAME')
cur = conn.cursor()
cur.execute("SELECT * FROM test")
for r in cur:
curr = conn.cursor()
sql = """UPDATE test SET count = 1 WHERE name = '%s'""" % r[1]
# print(sql)
try:
# Execute the SQL command
curr.execute(sql)
# Commit your changes in the database
conn.commit()
except:
# Rollback in case there is any error
conn.rollback()
curr.close()
cur.close()
conn.close()
另外,由于您提到您是python新手,所以每次运行INSERT、UPDATE或DELETE-like查询时,请记住提交。
希望有帮助。
关于python - python MySQL更新特定列fetchall(),我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/49192573/