title: Getting error "1366 Incorrect integer value: '1'" when importing file
body: <p>I'm trying to inline upload data stored in UTF-8 text files, and I have two problems. Firstly, there's currently no primary key set on this table, and it's not set to auto-increment or forced to be null at this point; the first column will be the intended primary key once all the data is loaded, and foreign keys will be added at that point.</p>
  
  <p>I received the following error:</p>
  
  <blockquote>
    <p>25 row(s) affected, 1 warning(s): 1366 Incorrect integer value: '1' for column 'idtable_file' at row 1 Records: 25  Deleted: 0  Skipped: 0  Warnings: 1</p>
  </blockquote>
  
  <p>when trying to run this:</p>
  
  <pre><code>LOAD DATA LOCAL INFILE '/path' INTO TABLE sandr.table_file 
  columns terminated by ','   
  LINES terminated by '\n'
  (idtable_file, owner_id, folder_id, @modified_date, @created_date, size, filename)
  SET modified_date = STR_TO_DATE(@modified_date,'%d/%m/%Y %T'),
      created_date = STR_TO_DATE(@created_date,'%d/%m/%Y %T')
  </code></pre>
  
  <p>on this table:</p>
  
  <pre><code>CREATE TABLE `table_file` (
    `idtable_file` int(11) DEFAULT NULL,
    `owner_id` int(11) DEFAULT NULL,
    `folder_id` int(11) DEFAULT NULL,
    `modified_date` datetime DEFAULT NULL,
    `created_date` datetime DEFAULT NULL,
    `size` int(11) DEFAULT NULL,
    `filename` varchar(255) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8
  </code></pre>
  
  <p>I'm doing something wrong but I've just started with MySQL so I'm stabbing in the dark a fair bit, any ideas on that?  Also, though the above SQL query works fine in PowerShell when it's just this:</p>
  
  <pre><code>LOAD DATA LOCAL INFILE '/path' INTO TABLE sandr.table_file 
  columns terminated by ','   
  LINES terminated by '\n'
  </code></pre>
  
  <p>It bombs out with:</p>
  
  <blockquote>
    <p>Exception calling "ExecuteNonQuery" with "0" argument(s): "Fatal error encountered during command execution."  </p>
  </blockquote>
  
  <p>if I add the adjustment to the date fields.</p>