Python MySQL不插入字符串变量

import pymysql

# 连接数据库
conn = pymysql.connect(host='localhost', user='root', password='password', db='database')
cursor = conn.cursor()

# 使用参数化查询
sql = "INSERT INTO table (column1, column2) VALUES (%s, %s)"
data = ('value1', 'value2')
cursor.execute(sql, data)

# 提交事务
conn.commit()

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

from sqlalchemy import create_engine, Column, String
from sqlalchemy.orm import sessionmaker
from sqlalchemy.ext.declarative import declarative_base

# 创建数据库引擎
engine = create_engine('mysql+pymysql://root:password@localhost/database')

# 创建会话
Session = sessionmaker(bind=engine)
session = Session()

# 创建映射类
Base = declarative_base()

class Table(Base):
    __tablename__ = 'table'
    column1 = Column(String, primary_key=True)
    column2 = Column(String)

# 插入数据
data = Table(column1='value1', column2='value2')
session.add(data)
session.commit()

# 关闭会话
session.close()