如何遍历数据库表并为列创建按钮

import mysql.connector
from tkinter import *

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

# 创建窗口
window = Tk()

# 查询数据库表结构
cursor = db.cursor()
cursor.execute("SHOW TABLES")
tables = cursor.fetchall()

# 遍历表名
for table in tables:
    table_name = table[0]
    
    # 查询表结构
    cursor.execute(f"DESCRIBE {table_name}")
    columns = cursor.fetchall()
    
    # 创建表格
    table_frame = Frame(window)
    table_frame.pack()
    
    # 创建表头
    header_frame = Frame(table_frame)
    header_frame.pack()
    for column in columns:
        label = Label(header_frame, text=column[0])
        label.pack(side=LEFT)
    
    # 创建按钮
    data_frame = Frame(table_frame)
    data_frame.pack()
    for column in columns:
        button = Button(data_frame, text="Button")
        button.pack(side=LEFT)

# 显示窗口
window.mainloop()

# 关闭数据库连接
db.close()