Update many records all at once using pymysql module.

pymysql_sample_update.py

def main():
    """
    Execute three actions.
    1. get id, new title from a file. e.g. [(title, id),(title, id)]
    2. update DB
    """
    id_titles = get_id_titles(EXPECTED_LIST)

    conn = pymysql.Connect(host=DB_HOST, db=DB, user=DB_USER, passwd=DB_PSWD, charset=CHARSET)
    cursor = conn.cursor()
    query = "UPDATE aegifpage SET page_title = %s where page_id = %s"
    cursor.executemany(query, id_titles)
    cursor.close()
    conn.commit()
    conn.close()
    print "updated successfully"