title: mysql select into outfile without any line termination character
body: <p>I try to print all the data from one field from a table into a file witout any line/field termination character. I would simply like to have all the rows concatenated and printed as one line in the output line. Here how I am doing it:</p>
  
  <pre><code>CREATE TABLE tbl (txt VARCHAR(100));
  INSERT INTO tbl VALUES ("text1");
  INSERT INTO tbl VALUES ("text2");
  INSERT INTO tbl VALUES ("text3");
  
  SELECT txt FROM tbl;
  
  SELECT txt INTO OUTFILE 'test.txt' LINES TERMINATED BY '' FROM tbl;
  </code></pre>
  
  <p>Unfortunely in the output I get tabs:</p>
  
  <pre><code>text1   text2   text3   
  </code></pre>
  
  <p>if I add </p>
  
  <pre><code>FIELDS TERMINATED BY ''
  </code></pre>
  
  <p>then all the 100 characters are printed into file (VARCHAR(100)</p>
  
  <pre><code>text1                                                                                               text2                                                                                               text3                                                                                               
  </code></pre>
  
  <p>What should I do to get everything contcatenated as:</p>
  
  <pre><code>text1text2text3
  </code></pre>
  
  <p>Many thanks in advance!</p>