无法识别的关键字Near Fields，在MySQL查询中使用INTO OUTFILE时终止 [英] Unrecognized key word Near Fields, Terminated When Using INTO OUTFILE in mysql query

问题描述

我已经使用以下查询将导出查询结果作为csv文件.

I have used following query for export query result as csv file..

查询

 SELECT * FROM city WHERE loc7 = 33 
INTO OUTFILE 'D://file.csv'
FIELDS TERMINATED BY ','

此查询已执行phpmyadmin 3.3.9和mysql version()5.5.8 ，并且该查询已针对无法识别的关键字 FIELDS 和无法识别的字词 version()5.7.13-0ubuntu0.16.04.2 中的> TERMINATED 如何解决此问题?有什么办法可以克服这个问题?

This above query has Excecuted phpmyadmin 3.3.9 and mysql version()5.5.8 and this same query has returned error for Unrecognized Keyword FIELDS and Unrecognized kerword TERMINATED in phpmyadmin 4.5.4 and mysql version()5.7.13-0ubuntu0.16.04.2 how to solve this problem? is there any way available to overcome this prob?

推荐答案

可能是FROM的位置错误.

It could be you have FROM in the wrong position.

来自MySQL文档:

选择a，b，a + b进入输出文件'/tmp/result.txt'字段终止'，'可选用'\ n'终止的''线
从test_table;

SELECT a,b,a+b INTO OUTFILE '/tmp/result.txt' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n'
FROM test_table;

尝试使用:

SELECT * 
INTO OUTFILE 'D://file.csv'
FIELDS TERMINATED BY ','
FROM city WHERE loc7 = 33 

这篇关于无法识别的关键字Near Fields，在MySQL查询中使用INTO OUTFILE时终止的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！