mysql 查询结果到文件

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

import pandas as pd
import mysql.connector

# 连接数据库
conn = mysql.connector.connect(user='your_user', password='your_password',
                               host='your_host', database='your_database')

# 执行查询
query = "SELECT * FROM your_table"
df = pd.read_sql(query, conn)

# 导出到CSV文件
df.to_csv('output.csv', index=False)

# 关闭连接
conn.close()

<?php
$servername = "your_host";
$username = "your_user";
$password = "your_password";
$dbname = "your_database";

// 创建连接
$conn = new mysqli($servername, $username, $password, $dbname);

// 检查连接
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

$sql = "SELECT * FROM your_table";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    $file = fopen("output.csv", "w");
    while($row = $result->fetch_assoc()) {
        fputcsv($file, $row);
    }
    fclose($file);
} else {
    echo "0 结果";
}

$conn->close();
?>