mysql如何导出数据表

mysqldump -u [username] -p[password] [database_name] [table_name] > [output_file.sql]

mysqldump -u root -p mydatabase mytable > mytable_backup.sql

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

import mysql.connector
import csv

# 连接数据库
db = mysql.connector.connect(
    host="localhost",
    user="root",
    password="password",
    database="mydatabase"
)

cursor = db.cursor()

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

# 导出为CSV文件
with open('mytable.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()

mysqldump --default-character-set=utf8 -u root -p mydatabase mytable > mytable_backup.sql