从 mysql Workbench 6.0 导出数据

# 从 MySQL Workbench 6.0 导出数据的简易指南

python
import mysql.connector
from mysql.connector import Error
# 连接到数据库
try:
    connection = mysql.connector.connect(host='your_host',
                                         database='your_database',
                                         user='your_user',
                                         password='your_password')
    if connection.is_connected():
        cursor = connection.cursor()
        # 执行导出查询
        query = "SELECT * FROM your_table"
        cursor.execute(query)
        data_to_export = cursor.fetchall()
        # 将数据写入文件
        with open('exported_data.txt', 'w') as file:
            for row in data_to_export:
                file.write(str(row) + '%
')
except Error as e:
    print("导出数据时发生错误：", e)
finally:
    if connection.is_connected():
        cursor.close()
        connection.close()
        print("导出完成，连接已关闭。")