python 连接mysql 语句_python mysql连接器多语句

import mysql.connector

connection = mysql.connector.connect(user="REMOVED",

password="REMOVED",

host="REMOVED",

database="REMOVED")

cur = connection.cursor()

# Latitude - remove letter A

cur.execute("UPDATE tau._inm_exportados_test_csv SET latitud = REPLACE (latitud, 'a=','');")

print("Latitude change remove letter A - executed!")

# Longitude - remove letter A

cur.execute("UPDATE tau._inm_exportados_test_csv SET longitud = REPLACE (longitud, 'a=','');")

print("Longitude change remove letter A - executed!")

# Latitude - MODIFY COLUMN

cur.execute("ALTER TABLE tau._inm_exportados_test_csv MODIFY COLUMN latitud DECIMAL(10,6);")

print("Latitude - MODIFY COLUMN - executed!")