title: Formatting input from excel to mysql using command line client
body: <p>I want to import data from excel to a mysql database using the command line client.
  This is an example of how my csv-file is built:</p>
  
  <pre>
  Name 1 | 1 | 2 | 3 |
  Name 2 | 1 | 2 | 3 |
  Name 3 | 1 | 2 | 3 |
  </pre>
  
  <p>I'm using the code:</p>
  
  <pre><code>LOAD DATA LOCAL INFILE 'path to file.csv'
    INTO TABLE table_name
    FIELDS TERMINATED BY ','
    LINES TERMINATED BY '\n';
  </code></pre>
  
  <p>I get the "Query OK" and with this code the formatting on the table should be almost exactly as the csv-file but I get this result:</p>
  
  <pre>
  | NULL | NULL | NULL | 
  | NULL | NULL | NULL |
  | NULL | NULL | NULL |
  </pre>
  
  <p>What is wrong?</p>