Select into OutFile导出数据语法不正确的是

在OceanBase V4.2版本中,Select into OutFile导出数据语法不正确的是
A. SELECT * INTO OUTFILE '/home/outfile/f1.sql’LI NES TERMINATED BY\n’FROM…
B. SELECT * INTO OUTFILE ‘/home/outfile/f1.txt’ TE RMINATED BY ’ | ’ FROM…
C. SELECT * INTO OUTFILE ‘/home/outfile/f1.csv’ F ROM …
D. SELECT * INTO OUTFILE ‘/home/outfile/f1.csv’ FIELDS TERMINATED BY ’ | ’ FROM…

3 个赞

感觉前三个都不对

AB吧不支持txt、sql格式,CD看不出来哪里错了


B. SELECT * INTO OUTFILE ‘/home/outfile/f1.txt’ TE RMINATED BY ’ | ’ FROM…

不正确的是B

二楼分析的比较正确,答案AB

你字多,你专业