mysql表结构生成表格

import mysql.connector
from prettytable import PrettyTable

# 连接到MySQL数据库
db = mysql.connector.connect(
    host="localhost",
    user="your_username",
    password="your_password",
    database="your_database"
)

cursor = db.cursor()

# 获取表结构信息
cursor.execute("SHOW CREATE TABLE your_table")
result = cursor.fetchone()

# 解析表结构信息
table_name = result[0]
create_table_sql = result[1]

# 使用PrettyTable生成表格
table = PrettyTable()
table.field_names = ["Column", "Type", "Null", "Key", "Default", "Extra"]
table.align["Column"] = "l"
table.align["Type"] = "l"
table.align["Null"] = "l"
table.align["Key"] = "l"
table.align["Default"] = "l"
table.align["Extra"] = "l"

# 解析CREATE TABLE语句
import re
columns = re.findall(r"`([^`]+)`", create_table_sql)
types = re.findall(r"VARCHAR\((\d+)\)|INT|FLOAT|TEXT|BLOB", create_table_sql)
nulls = re.findall(r"NULL", create_table_sql)
keys = re.findall(r"KEY `([^`]+)`", create_table_sql)
defaults = re.findall(r"DEFAULT '([^']+)'", create_table_sql)
extras = re.findall(r"AUTO_INCREMENT", create_table_sql)

for i in range(len(columns)):
    table.add_row([columns[i], types[i], nulls[i], keys[i] if i < len(keys) else "", defaults[i] if i < len(defaults) else "", extras[i] if i < len(extras) else ""])

# 打印表格
print(table)

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