import mysql.connector
# Establish the connection
conn = mysql.connector.connect(
host="your_host",
user="your_username",
password="your_password",
database="your_database"
)
# Create a cursor to query the database
cursor = conn.cursor()
# Execute an update query
update_query = "UPDATE your_table SET column1 = 'new_value' WHERE condition;"
cursor.execute(update_query)
# Execute a delete query
delete_query = "DELETE FROM your_table WHERE condition;"
cursor.execute(delete_query)
# Commit the changes to the database
conn.commit()
# Close the cursor and the connection
cursor.close()
conn.close()