导出mysql部分数据

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

mysqldump -u username -p database_name table_name --where="condition=value" > /path/to/your/file.sql

import pymysql

# 连接数据库
conn = pymysql.connect(host='localhost', user='username', password='password', db='database_name')
cursor = conn.cursor()

# 执行查询
sql = "SELECT * FROM your_table WHERE condition = %s"
cursor.execute(sql, ('value',))

# 将结果写入文件
with open('/path/to/your/file.csv', 'w') as f:
    for row in cursor.fetchall():
        f.write(','.join(str(x) for x in row) + '\n')

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

GRANT SELECT ON database_name.table_name TO 'username'@'localhost';

mkdir -p /path/to/your
chmod 755 /path/to/your

SELECT * FROM your_table WHERE condition = 'value' INTO OUTFILE '/path/to/your/file.csv'
FIELDS TERMINATED BY ',' 
ENCLOSED BY '"'
LANS TERMINATED BY '
';