title: LOAD DATA INFILE error in MySQL
body: <p>I try to import csv data into mySQL (microsoft slq server 2014 on windows 7). I use the following code</p>
  
  <pre><code>USE [DataAnalytics]
  GO
  
  SET ANSI_NULLS ON
  GO
  
  SET QUOTED_IDENTIFIER ON
  GO
  
  SET ANSI_PADDING ON
  GO
  
  DROP TABLE [dbo].[npi_yy]
  
  CREATE TABLE [dbo].[npi_yy](
  
  [NPI] [NUMERIC] (10) NULL,
  [Entity Type Code] [NUMERIC] (1) NULL,
  [Replacement NPI] [NUMERIC] (10) NULL,
  [Employer Identification Number (EIN)] [VARCHAR] (9) NULL,
  [Provider Organization Name (Legal Business Name)] [VARCHAR] (70) NULL
  ) ON [PRIMARY]
  
  GO
  
  SET ANSI_PADDING ON
  GO
  
  LOAD DATA INFILE 
  
      'c:\data\npidata_20050523-20160612_sample2.csv'
  
  INTO TABLE [dbo].[npi_yy]
  
    FIELDS TERMINATED BY ',' ENCLOSED BY '"'
  
    LINES TERMINATED BY '\r\n'
  
    IGNORE 1 LINES;
  </code></pre>
  
  <p>And got an error:</p>
  
  <pre><code>Msg 102, Level 15, State 1, Line 354
  Incorrect syntax near 'INFILE'.
  </code></pre>
  
  <p>I checked that <code>CREATE TABLE</code> worked by looking at the empty table.
  and checked <code>c:\data\npidata_20050523-20160612_sample2.csv</code> exists by opening it by putting the filename in explore</p>
  
  <p>Head of the csv:</p>
  
  <pre><code>"NPI","Entity Type Code","Replacement NPI","Employer Identification Number (EIN)","Provider Organization Name (Legal Business Name)"
  "1588667638","1","","",""
  "1497758544","2","","&lt;UNAVAIL&gt;","CUMBERLAND COUNTY HOSPITAL SYSTEM
  "1306849450","1","","",""
  "1215930367","1","","",""
  "1023011178","2","","&lt;UNAVAIL&gt;","NAPA VALLEY HOSPICE &amp; ADULT DAY SERVICES"
  </code></pre>
  
  <p>Anybody know what was wrong? Any help's appreciated.</p>