mysql 指定表数据导出

mysqldump -u username -p database_name table_name > export_file.sql

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

import mysql.connector
import csv

# 连接到MySQL数据库
db = mysql.connector.connect(
    host="localhost",
    user="username",
    password="password",
    database="database_name"
)

cursor = db.cursor()

# 执行查询
cursor.execute("SELECT * FROM table_name")

# 将结果写入CSV文件
with open('export_file.csv', 'w', newline='') as file:
    writer = csv.writer(file)
    writer.writerow([i[0] for i in cursor.description])  # 写入列名
    writer.writerows(cursor)

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

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

chmod 755 /path/to/export_file.csv

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