mysql 导出一列数据

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

mysqldump -u username -p --no-create-info --skip-triggers --compact --skip-comments --skip-dump-date --tab=/path/to/output_dir database_name users email > /path/to/output.sql

import mysql.connector
import csv

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

# 执行SQL查询
query = "SELECT email FROM users"
cursor.execute(query)

# 将结果写入CSV文件
with open('/path/to/output.csv', 'w', newline='') as csvfile:
    writer = csv.writer(csvfile)
    writer.writerow(['email'])  # 写入表头
    for (email,) in cursor:
        writer.writerow([email])

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

SELECT email INTO OUTFILE '/path/to/output.csv'
CHARSET='utf8mb4'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM users;