title: mysqlimport - Import CSV File in MS Windows XAMPP emvironment
body: <p>I am trying to import a CSV file from to a mysql database from the command line. This will be later incorporated into a Windows batch file.</p>
  
  <pre><code>mysqlimport -u user -puserpw --columns=ID,CID,Alerted --fields-terminated-by=',' --local School Customer.csv  
  </code></pre>
  
  <p>All the data loads into the first column in the Customer table.
  I want to correctly import data from the CSV to the appropriate column.</p>
  
  <p>CSV Data format:</p>
  
  <pre><code>ID,CID,Alerted
  1,CS,N
  2,CS,N
  3,CS,N
  </code></pre>
  
  <p>I would like to use mysqlimport since this will be easier to add to a Windows batch file.
  How can I do this please help?</p>