如何使用Python在SQL中插入或更新

import sqlite3

conn = sqlite3.connect('database.db')

cursor = conn.cursor()

insert_query = "INSERT INTO table_name (column1, column2) VALUES (?, ?)"
update_query = "UPDATE table_name SET column1 = ? WHERE condition"

# 插入数据
data = ('value1', 'value2')
cursor.execute(insert_query, data)

# 更新数据
data = ('new_value', 'condition_value')
cursor.execute(update_query, data)

conn.commit()

cursor.close()
conn.close()