如何使用while循环在3个不同的表中回显数据库的特定列

import pymysql

# 连接数据库
conn = pymysql.connect(host='数据库主机地址', port=3306, user='用户名', password='密码', db='数据库名')

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

# 查询table1的column1列
sql1 = "SELECT column1 FROM table1"

# 查询table2的column2列
sql2 = "SELECT column2 FROM table2"

# 查询table3的column3列
sql3 = "SELECT column3 FROM table3"

# 执行查询语句1
cursor.execute(sql1)
result1 = cursor.fetchall()

# 使用while循环回显查询结果1
while result1:
    for row in result1:
        print(row[0])  # 回显column1列的值
    result1 = cursor.fetchall()

# 执行查询语句2
cursor.execute(sql2)
result2 = cursor.fetchall()

# 使用while循环回显查询结果2
while result2:
    for row in result2:
        print(row[0])  # 回显column2列的值
    result2 = cursor.fetchall()

# 执行查询语句3
cursor.execute(sql3)
result3 = cursor.fetchall()

# 使用while循环回显查询结果3
while result3:
    for row in result3:
        print(row[0])  # 回显column3列的值
    result3 = cursor.fetchall()

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