mysql - OUTFILE MySQL 不能与联合一起工作

Question

SELECT t1.email FROM(
SELECT email, SIGN(Locked1) FROM table WHERE SIGN(Locked1) <> 1
UNION
SELECT email, SIGN(Locked2) FROM table WHERE SIGN(Locked2) <> 1
UNION DISTINCT
SELECT email, SIGN(Locked3) FROM table WHERE SIGN(Locked3) <> 1
)t1
INTO OUTFILE 'emailDump.csv' FIELDS TERMINATED BY "," LINES TERMINATED BY "\n";

此查询运行但未将任何内容放入输出文件。如果我在没有最后一行的情况下运行查询，这些行会显示出来，所以这不是因为联合没有产生结果。我使用的是 Windows 8.1 64 位。

Answer 1

可能是地点。以下语法是正确的。我们将把它放在 C: 的根目录中。

SELECT email
FROM table 
WHERE 
SIGN(Locked1) <> 1 or
SIGN(Locked2) <> 1 or 
SIGN(Locked3) <> 1
INTO OUTFILE 'C:\emailDump.csv' FIELDS TERMINATED BY "," LINES TERMINATED BY "\n";