添加包含来自同一数据库的两个不同表的值的两个变量

import mysql.connector

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

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

# 查询表1的数据
query1 = "SELECT column1 FROM table1"
cursor.execute(query1)
result1 = cursor.fetchall()

# 查询表2的数据
query2 = "SELECT column2 FROM table2"
cursor.execute(query2)
result2 = cursor.fetchall()

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

# 将结果添加到变量中
variable1 = []
variable2 = []

for row in result1:
    variable1.append(row[0])

for row in result2:
    variable2.append(row[0])

# 打印结果
print("Variable 1:", variable1)
print("Variable 2:", variable2)