Update Command SQL

sql_update_command.py

def updateData(df):
    data = df.loc[:,['profesi_master','updated_at','userid']].values.tolist()

    sql_update ="""
        UPDATE tblcustomfieldsvalues
        SET value = %s, updated_at = %s
        WHERE relid = %s
        """
    mycursor1 = connWarehouse.cursor()
    mycursor1.executemany(sql_update,data)
    connWarehouse.commit()
    
    mycursor1.close()
    connWarehouse.close()