mysql 导出为htm

import mysql.connector
from mysql.connector import Error

def export_to_html(table_name):
    try:
        # 连接到MySQL数据库
        connection = mysql.connector.connect(
            host='localhost',
            database='your_database',
            user='your_username',
            password='your_password'
        )

        if connection.is_connected():
            cursor = connection.cursor()
            # 查询表中的所有数据
            cursor.execute(f"SELECT * FROM {table_name}")
            records = cursor.fetchall()

            # 生成HTML表格
            html_table = "<table border='1'>\n"
            # 获取列名
            column_names = [desc[0] for desc in cursor.description]
            html_table += "<tr>\n"
            for column_name in column_names:
                html_table += f"<th>{column_name}</th>\n"
            html_table += "</tr>\n"
            # 获取数据行
            for record in records:
                html_table += "<tr>\n"
                for value in record:
                    html_table += f"<td>{value}</td>\n"
                html_table += "</tr>\n"
            html_table += "</table>"

            # 将HTML表格写入文件
            with open(f"{table_name}.html", "w") as file:
                file.write(html_table)

            print(f"数据已成功导出到 {table_name}.html")

    except Error as e:
        print(f"连接MySQL数据库时出错: {e}")
    finally:
        if connection.is_connected():
            cursor.close()
            connection.close()

# 调用函数导出数据
export_to_html('your_table_name')