当模式中有相同的表时，如何在运行时动态传递模式名

import mysql.connector

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

# 创建游标
cursor = conn.cursor()

# 定义模式名参数
schema_name = "your_schema_name"

# 执行查询
query = "SELECT * FROM {}.your_table".format(schema_name)
cursor.execute(query)

# 获取结果
result = cursor.fetchall()

# 关闭游标和连接
cursor.close()
conn.close()

import mysql.connector

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

# 创建游标
cursor = conn.cursor()

# 定义模式名变量
schema_name = "your_schema_name"

# 拼接SQL语句
query = "SELECT * FROM " + schema_name + ".your_table"

# 执行查询
cursor.execute(query)

# 获取结果
result = cursor.fetchall()

# 关闭游标和连接
cursor.close()
conn.close()