title: What do the following MySQL csv import query terms mean?
body: <p>For MySQL, I found the following query to import a CSV file:</p>
  
  <pre><code>LOAD DATA LOCAL INFILE '/example.csv'
  INTO TABLE exampletable
  FIELDS TERMINATED BY ','
  OPTIONALLY ENCLOSED BY '"'
  ESCAPED BY '\\'
  LINES TERMINATED BY '\r\n'
  IGNORE 1 LINES
  (example_field_name,example_field_city,example_field_state);
  </code></pre>
  
  <p>I'm just starting to learn, so please forgive the trivial question, but I'm wondering if someone can explain the following parts of this in a simpler way than what's in the MySQL help docs:</p>
  
  <p>What does this mean?</p>
  
  <pre><code>OPTIONALLY ENCLOSED BY '"'
  </code></pre>
  
  <p>What does this mean?</p>
  
  <pre><code>ESCAPED BY '\\'
  </code></pre>
  
  <p>What do the \r and \n mean in the following?</p>
  
  <pre><code>LINES TERMINATED BY '\r\n'
  </code></pre>
  
  <p>Thank you for your help.</p>