title: Import CSV to MySQL With Fewer Columns Than Destination Table
body: <p>Is there a way to import a CSV into MySQL where the column numbers do not match?</p>
  
  <p>I have a MySQL "Employees" table which we update once a month with a CSV file.  I have added two additional columns to the "Employees" table that are relevant to our needs.  Importing the table data, through MySQL Workbench, with the following SQL statement:</p>
  
  <pre><code>LOAD DATA LOCAL INFILE 'EmployeeDump-March.csv' REPLACE INTO TABLE employees
  FIELDS TERMINATED BY ','
  ENCLOSED BY '"'
  LINES TERMINATED BY '\n'
  </code></pre>
  
  <p>I receive the following error, which is absolutely correct... the column numbers don't match:</p>
  
  <pre><code>Error Code: 1261. Row 1 doesn't contain data for all columns    7.426 sec
  </code></pre>
  
  <p>The two extra fields have default values.</p>
  
  <p>Is there a way to supress this error and have MySQL ignore those last two columns, leaving them alone?</p>