mysql怎么导出查询数据

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

mysqldump -u your_username -p your_database --no-create-info --skip-triggers --compact -t -w "your_condition" > /path/to/your/output/file.sql

import pymysql

# 连接数据库
conn = pymysql.connect(host='your_host', user='your_username', password='your_password', db='your_database')
cursor = conn.cursor()

# 执行查询语句
cursor.execute('SELECT * FROM your_table WHERE your_condition')

# 将结果导出到CSV文件
with open('/path/to/your/output/file.csv', 'w', newline='') as csvfile:
    writer = csv.writer(csvfile)
    writer.writerow([i[0] for i in cursor.description])  # 写入列名
    writer.writerows(cursor.fetchall())

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