python循环执行MySQL的修改语句

py执行mysql的修改语句，简单小例子。

#连接MySQL
connmy = pymysql.connect("ip","user","pwd","dbase")
surs = connmy.cursor()

sql = "update student set sname = '李四' where sid = 1;"

try:
   # 执行SQL语句
   surs .execute(sql)
   # 提交到数据库执行
   connmy.commit()
except:
   # 发生错误时回滚
   connmy.rollback()

surs.close()
connmy.close()