title: Bulk import CSV into MySQL by ignoring variable CSV columns
body: <p>I am trying to implement a bulk import via bash shell (Windows) of multiple CSV files in MySQL database. I am running into the issue that my CSV files (500+) have two different number of columns.</p>
  
  <p><strong>CSV type 1</strong></p>
  
  <pre><code>No,Latitude,Longitude,Name,Altitude,Description,Symbol,Filename
  1,-26.976823,21.836022,"1608",912.7,"1608","Flag","W80716pmNATV"
  </code></pre>
  
  <p><strong>CSV type 2</strong></p>
  
  <pre><code>No,Latitude,Longitude,Name,Altitude,Symbol,Filename
  1,-26.977080,21.833260,"0649SB",902.0,"Flag","W81018amDH.mps"
  </code></pre>
  
  <p>How can I manipulate:</p>
  
  <pre><code>LOAD DATA INFILE ' VH110131pmBES.mps.csv '
  INTO TABLE `gpsdata`.`import`
  FIELDS TERMINATED BY ',' ENCLOSED BY '"'
  LINES TERMINATED BY '\r\n'
  IGNORE 1 LINES (@dummy, `Latitude`, `Longitude`, `Name`, `Altitude`, @dummy, `Filename`)'
  </code></pre>
  
  <p>to incorporate both files in one bash code?
  I do have a unique ID field at the beginning autoincrementing.</p>