import mysql.connector

# 连接到MySQL数据库
cnx = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword",
  database="yourdatabase"
)

# 创建游标对象
cursor = cnx.cursor()

# 查询数据
query = "SELECT * FROM yourtable"
cursor.execute(query)
result = cursor.fetchall()

# 输出查询结果
for row in result:
  print(row)

# 插入数据
query = "INSERT INTO yourtable (column1, column2) VALUES (%s, %s)"
values = ("value1", "value2")
cursor.execute(query, values)
cnx.commit()

# 更新数据
query = "UPDATE yourtable SET column1 = %s WHERE column2 = %s"
values = ("new value", "old value")
cursor.execute(query, values)
cnx.commit()

# 删除数据
query = "DELETE FROM yourtable WHERE column = %s"
value = "value1"
cursor.execute(query, (value,))
cnx.commit()

# 关闭游标和数据库连接
cursor.close()
cnx.close()