title: What is the issue with "FIELDS TERMINATED BY" and "LINES TERMINATED BY"?
body: <p>So I have created a mysql table called specs and I want to import into this table a csv file. </p>
  
  <pre><code>CREATE TABLE specs (
    `Id` INT NOT NULL,
    `Brand` VARCHAR(40) NOT NULL,
    `Horsepower` INT NOT NULL,
    `Range` INT NOT NULL,
    PRIMARY KEY (Id)
  );
  </code></pre>
  
  <p>The csv data looks like the following</p>
  
  <pre><code>ID\Brand\Horsepower\Range
  1\Mercedes Benz\237\634
  2\Audi\345\567
  3\Ford\190\456
  4\BMW\278\547
  5\Toyota\123\364
  6\Fiat\90\289
  7\Daihatsu\120\450
  8\Jeep\500\670
  9\Seat\119\289
  10\Mitsubishi\78\410
  </code></pre>
  
  <p>And this is how I import the data, but the table is filled with zeros. Where is the issue. I think the problem is something with FIELDS and LINES TERMINATED BY.</p>
  
  <pre><code>LOAD DATA LOCAL INFILE '/Users/anilyelin/Desktop/cars.csv'
  INTO TABLE specs
  FIELDS TERMINATED BY '\\'
  LINES TERMINATED BY '\n'
  IGNORE 1 ROWS
  </code></pre>
  
  <p>The output looks like the following:</p>
  
  <pre><code>mysql&gt; select * from specs;
  +----+-------+------------+-------+
  | Id | Brand | Horsepower | Range |
  +----+-------+------------+-------+
  |  1 |       |          0 |     0 |
  |  2 |       |          0 |     0 |
  |  3 |       |          0 |     0 |
  |  4 |       |          0 |     0 |
  |  5 |       |          0 |     0 |
  |  6 |       |          0 |     0 |
  |  7 |       |          0 |     0 |
  |  8 |       |          0 |     0 |
  |  9 |       |          0 |     0 |
  | 10 |       |          0 |     0 |
  +----+-------+------------+-------+
  10 rows in set (0,00 sec)
  </code></pre>