Update Query

import mysql.connector
import re

conn = mysql.connector.Connect(host='localhost', user='root', password='secret', database='sakila', auth_plugin='mysql_native_password')

cursor = conn.cursor()
cursor2 = conn.cursor()

query = "SELECT ID, Info FROM world_x.city"

cursor.execute(query)

result = cursor.fetchall()

for row in result:
    strw = str(row[1])
    Population = re.findall('\d+', strw)[0]
    query2 = "UPDATE world_x.city SET Population={} WHERE ID={}".format(Population, row[0])
    cursor2.execute(query2)
    conn.commit()
    print("Record updated successfully")