title: Importing partial data into MySQL from CSV
body: <p>I have a CSV that is a <strong>partial projection</strong> of an origin table. I have the same table structure in my DB.</p>
  
  <p>I would like to import only those columns into my DB, given that no additional <code>NOT NULL</code> constraints are in place (I explicitly disabled some of them). I don't know how to import them.</p>
  
  <p>I have tried the following: from MySQL Workbench, right click on table and then <code>Edit table data</code>, then on the screen I tried the "Import records from an external file" button, loaded the CSV file but I got the following error:</p>
  
  <pre><code>[Window Title]
  MySQL Workbench
  
  [Main Instruction]
  Error importing recordset
  
  [Content]
  error calling Python module function SQLIDEUtils.importRecordsetDataFromFile
  
  [OK]
  </code></pre>
  
  <p>The column names are the same as in the DB but these are partial (not all columns as DB). The table is currently empty.</p>
  
  <p>What can I do to import the data into MySQL?</p>