title: Is there a reason LOAD DATA will not accept pipe delimited files
body: <p>When I try to run this:</p>
  
  <p><div class="snippet" data-lang="js" data-hide="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>LOAD DATA INFILE 'MyFile.txt'
  INTO TABLE CLIMATE_DATA
  FIELDS TERMINATED BY '|'
  LINES TERMINATED BY '\r\n'
  (
   STATION_ID,
   WBAN_ID,
   DATE,
   MEAN_TEMP,
   NUM_OBSERVATIONS_TEMP,
   MEAN_DEW_POINT,
   NUM_OBSERVATIONS_DEW_POINT,
   MEAN_SEA_LEVEL_PRESSURE,
   NUM_OBSERVATIONS_SEA_LEVEL_PRESSURE,
   MEAN_STATION_PRESSURE,
   NUM_OBSERVATIONS_STATION_PRESSURE,
   MEAN_VISIBILITY,
   NUM_OBSERVATIONS_MEAN_VISIBILITY,
   MEAN_WIND_SPEED,
   NUM_OBSERVATIONS_WIND_SPEED,
   MAX_WIND_SPEED,
   MAX_WIND_GUST,
   MAX_TEMP,
   MAX_TEMP_FLAG,
   MIN_TEMP,
   MIN_TEMP_FLAG,
   TOTAL_PRECIPITATION,
   TOTAL_PRECIPITATION_FLAG,
   SNOW_DEPTH,
   WEATHER_PHENOMENON 
  )
  IGNORE 1 LINES;</code></pre>
  </div>
  </div>
  </p>
  
  <p>I get: "Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''' at line 3"</p>
  
  <p>It will work fine with ','. The syntax appears to be correct. Not sure what I'm doing wrong.</p>