我试图执行这个MySQL导入一些数据到csv文件。
SELECT *
FROM purchase WHERE purchase.PO_DATE >= '1-1-2016'
INTO OUTFILE "D:\Reports\Jan.csv"
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY 'n'
但是我正在接收输出
Static analysis:
11 errors were found during analysis.
Unrecognized keyword. (near "FIELDS" at position 99)
Unrecognized keyword. (near "TERMINATED" at position 106)
Unrecognized keyword. (near "BY" at position 117)
Unexpected token. (near "','" at position 120)
Unrecognized keyword. (near "ENCLOSED" at position 125)
Unrecognized keyword. (near "BY" at position 134)
Unexpected token. (near "'"'" at position 137)
Unrecognized keyword. (near "LINES" at position 142)
Unrecognized keyword. (near "TERMINATED" at position 148)
Unrecognized keyword. (near "BY" at position 159)
Unexpected token. (near "'n'" at position 162)
SQL query: Documentation
SELECT * FROM purchase WHERE purchase.PO_DATE >= '1-1-2016' INTO OUTFILE "D:\Reports\Jan.csv" FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY 'n'
谁知道怎么解决这个问题?
关于您的输出文件的信息应该在SELECT
和FROM
子句之间指定:
SELECT *
INTO OUTFILE "D:ReportsJan.csv"
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY 'n'
FROM purchase
WHERE purchase.PO_DATE >= '1-1-2016'
MySQL 5.7参考手册| LOAD DATA INFILE语法
from子句位置错误应该是
SELECT *
INTO OUTFILE "D:ReportsJan.csv"
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY 'n'
FROM purchase
WHERE purchase.PO_DATE >= '1-1-2016'