将变量中的整数添加到mysql列

import mysql.connector

# 连接到MySQL数据库
cnx = mysql.connector.connect(user='username', password='password', host='localhost', database='mydatabase')
cursor = cnx.cursor()

# 创建一个表格，包含一个整数列
table_name = 'mytable'
column_name = 'myinteger'
create_table_query = f"CREATE TABLE IF NOT EXISTS {table_name} (id INT AUTO_INCREMENT PRIMARY KEY, {column_name} INT)"
cursor.execute(create_table_query)

# 插入数据到表格中
insert_query = f"INSERT INTO {table_name} ({column_name}) VALUES (%s)"
values = (10,)
cursor.execute(insert_query, values)

# 更新整数列的值
update_query = f"UPDATE {table_name} SET {column_name} = {column_name} + %s"
update_value = (5,)
cursor.execute(update_query, update_value)

# 查询更新后的数据
select_query = f"SELECT * FROM {table_name}"
cursor.execute(select_query)
results = cursor.fetchall()
print(results)

# 关闭连接
cursor.close()
cnx.close()