MySQL成outfile格式 [英] MySQL into outfile formatting

问题描述

select * 
  INTO OUTFILE 'outfile.txt'
  FIELDS TERMINATED by ','
  LINES TERMINATED BY '\n'
  from nGrams

有什么方法可以修改此查询以返回一行中的每一行?

Is there any way I can modify this query to return each row on one line?

推荐答案

似乎正是它已经要做的.

Seems like thats exactly what it would do already.

但是，如果您在Windows上执行此操作，则可能要使用LINES TERMINATED BY '\r\n'，或者某些糟糕的文本编辑器(例如记事本)可能本身不会将\n视为换行符

However, if you are doing this on Windows, you might want to use LINES TERMINATED BY '\r\n' or some crappy text editors (e.g. notepad) might not see \n by itself as a line break

这篇关于MySQL成outfile格式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！