mysql查询数据导出sql

GRANT FILE ON *.* TO 'your_user'@'localhost';

SELECT * INTO OUTFILE '/path/to/file.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
CHARACTER SET utf8mb4;

SELECT * INTO OUTFILE '/path/to/file_part1.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
LIMIT 10000;

mysqldump -u your_user -p your_database > /path/to/backup.sql

import mysql.connector
import csv

# 连接数据库
cnx = mysql.connector.connect(user='your_user', password='your_password',
                              host='localhost', database='your_database')

cursor = cnx.cursor()

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

# 导出数据到CSV文件
with open('/path/to/output.csv', 'w', newline='', encoding='utf-8') as csvfile:
    csv_writer = csv.writer(csvfile)
    # 写入列名
    column_names = [i[0] for i in cursor.description]
    csv_writer.writerow(column_names)
    # 写入数据
    csv_writer.writerows(cursor)

cursor.close()
cnx.close()