mysql数据导出txt格式

mysqldump -u username -p database_name --compatible=ansi --skip-extended-insert --compact --no-create-info --skip-quote-names --skip-comments -t -T /path/to/output/directory table_name --fields-terminated-by=',' --fields-enclosed-by='"'

import mysql.connector
import csv

# 连接数据库
cnx = mysql.connector.connect(user='username', password='password', host='host', database='database_name')
cursor = cnx.cursor()

# 执行查询
query = "SELECT * FROM table_name"
cursor.execute(query)

# 导出为CSV文件
with open('output.csv', 'w', newline='', encoding='utf-8') as csvfile:
    csv_writer = csv.writer(csvfile)
    csv_writer.writerow([i[0] for i in cursor.description])  # 写入表头
    csv_writer.writerows(cursor)

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

cnx = mysql.connector.connect(user='username', password='password', host='host', database='database_name', charset='utf8')

query = "SELECT field1, field2, field3 FROM table_name"

# 分批次导出数据
batch_size = 1000
offset = 0
while True:
    query = f"SELECT * FROM table_name LIMIT {batch_size} OFFSET {offset}"
    cursor.execute(query)
    rows = cursor.fetchall()
    if not rows:
        break
    with open('output.csv', 'a', newline='', encoding='utf-8') as csvfile:
        csv_writer = csv.writer(csvfile)
        csv_writer.writerows(rows)
    offset += batch_size