mysql - 使用此代码将 mysql 表导出到 csv - 但我需要 MAC 而非 PC 的语法

Question

windows环境代码如下:

SELECT *
INTO OUTFILE '/documents/products.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
ESCAPED BY '\\'
LINES TERMINATED BY '\n'
FROM products

MAC 环境只需要第二行 - 谢谢。

Answer 1

首先，您需要将FROM 子句放在INTO OUTFILE 之前。

其次，确保 OUTFILE 中指定的目录具有 MySQL 写入它的能力(在您的例子中是 /documents)。与尝试更改另一个目录的权限以接受来自 MySQL 数据库的写入相比，写入 /tmp(MySQL 已经默认具有写入权限)要容易得多。

SELECT * 
    FROM products 
    INTO OUTFILE '/tmp/products.csv' 
         FIELDS TERMINATED BY ',' 
         ENCLOSED BY '"' 
         ESCAPED BY '\\' 
         LINES TERMINATED BY '\n';