mysql select导出csv

SELECT * INTO OUTFILE '/path/to/output.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM your_table;

mysqldump -u username -p database_name table_name --fields-terminated-by=',' --fields-enclosed-by='"' --lines-terminated-by='\n' > output.csv

import mysql.connector
import csv

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

# 查询数据
query = "SELECT * FROM your_table"
cursor.execute(query)

# 导出为 CSV 文件
with open('output.csv', 'w', newline='') as csvfile:
    csvwriter = csv.writer(csvfile)
    csvwriter.writerow([i[0] for i in cursor.description])  # 写入列名
    csvwriter.writerows(cursor)

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

sudo chown mysql:mysql /path/to/output
sudo chmod 755 /path/to/output

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

import mysql.connector
import csv

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

# 查询数据
query = "SELECT * FROM your_table"
cursor.execute(query)

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

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