MySQL & python update 语句

作用

将表tableName中id为idKey的值为keyVal的记录中的modId属性的值改为modVal

代码

def update(tableName, keyId, keyVal, modId, modVal):
    try:
        db = pymysql.connect(
            host='127.0.0.1',
            port=3306,
            user='root',
            passwd='123456',
            db='wuliu',
            charset='utf8'
        )
        cursor = db.cursor()  # 创建游标
        sql = "UPDATE %s SET %s = %s WHERE %s = %s"
        par = (tableName, modId, modVal, keyId, keyVal)

        cursor.execute(sql, par)
        db.commit()

        print('update 更新成功')
        cursor.close()
        db.close()
    except Exception as e:
        db.rollback()  # 发生错误时回滚
        print(e)
        print('update 更新失败')