title: Row 1 doesn't contain data for all columns
body: <p>I am trying to upload a csv into MySQL using the Workbench, and so far all my attempts have proven fruitless.</p>
  
  <p>I initially attempted to use the "Upload" function, but it complained about any null/empty fields I had.</p>
  
  <p>I am now attempting to use this function:</p>
  
  <pre><code>LOAD DATA infile 'C:\\temp\\SubEq.csv'
  INTO TABLE cas_asset_register.subequipment
  fields terminated BY ','
  lines terminated BY '\n'
  (seid, parentme, @vparentse, name, status, description, equipmenttype, comments, removed, active, @vsupplierid)
  SET
  ParentSE = nullif(@vparentse,''),
  SupplierId = nullif(@vsupplierid,'')
  ;
  </code></pre>
  
  <p>But again, it appears to be complaining about (possibly) the same thing:</p>
  
  <blockquote>
    <p>Error Code: 1261. Row 1 doesn't contain data for all columns</p>
  </blockquote>
  
  <p>I have had a look at the answers for <a href="https://stackoverflow.com/questions/21646781/mysql-error-1261-row-1-doesnt-contain-data-for-all-columns">this</a> and <a href="https://stackoverflow.com/questions/27219491/row-does-not-contain-data-for-all-columns">this</a> question, but neither have solved my issue.</p>
  
  <p>The table create query:</p>
  
  <pre><code>CREATE TABLE `subequipment` (
    `SEId` int(11) NOT NULL AUTO_INCREMENT,
    `ParentME` int(11) DEFAULT NULL,
    `ParentSE` int(11) DEFAULT NULL,
    `Name` varchar(255) DEFAULT NULL,
    `Status` varchar(100) DEFAULT NULL,
    `Description` varchar(255) DEFAULT NULL,
    `EquipmentType` int(11) DEFAULT NULL,
    `Comments` text,
    `Removed` tinyint(1) NOT NULL DEFAULT '0',
    `Active` tinyint(1) DEFAULT '1',
    `SupplierId` int(11) DEFAULT NULL,
    PRIMARY KEY (`SEId`),
    UNIQUE KEY `Unique_Constraint_ME` (`Name`,`ParentME`,`Active`),
    UNIQUE KEY `Unique_Constraint_SE` (`Name`,`ParentSE`,`Active`),
    KEY `ParentME` (`ParentME`),
    KEY `ParentSE` (`ParentSE`),
    KEY `EquipmentType` (`EquipmentType`),
    KEY `fk_subequipment_supplierequipment` (`SupplierId`),
    KEY `fk_subequipment_status_idx` (`Status`),
    CONSTRAINT `fk_subequipment_majorequipment` FOREIGN KEY (`ParentME`) REFERENCES `majorequipment` (`MEId`) ON DELETE CASCADE ON UPDATE CASCADE,
    CONSTRAINT `fk_subequipment_status` FOREIGN KEY (`Status`) REFERENCES `componentstatus` (`StatusName`) ON UPDATE CASCADE,
    CONSTRAINT `fk_subequipment_subequipment` FOREIGN KEY (`ParentSE`) REFERENCES `subequipment` (`SEId`) ON DELETE CASCADE ON UPDATE CASCADE,
    CONSTRAINT `fk_subequipment_supplierequipment` FOREIGN KEY (`SupplierId`) REFERENCES `supplierinfo_equipment` (`SupplierId`) ON UPDATE CASCADE,
    CONSTRAINT `fk_subequipment_userdefinedcode` FOREIGN KEY (`EquipmentType`) REFERENCES `userdefinedcode` (`UDCId`) ON UPDATE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  </code></pre>
  
  <p>As you can see from my upload query, I am expecting "ParentSE" and "SupplierId" to be empty, even though they are foreign key fields.</p>
  
  <p>Each line of the csv is properly indexed (i.e. there <em>are</em> enough fields to match the table):</p>
  
  <pre><code>1,1,,P7YCGPF,Abg va hfr,Nfcver Npre Yncgbc,13,"Qngr npdhverq: 61/52/7566
  Zbqry: 0297T
  Frevny Ahzore: YKE057551588125P16156",0,1,
  </code></pre>
  
  <p>What's going wrong?</p>