title: I can't load a MySQL table containing only integer columns from a file
body: <p>I'm trying to import data to a MySQL table.</p>
  <p>The table :</p>
  <pre><code>CREATE TABLE `MYTABLE` (
    `F1` bigint(20) NOT NULL,
    `F2` bigint(20) NOT NULL,
    `F3` int(11) NOT NULL,
    `F4` bigint(20) DEFAULT NULL,
    `F5` tinyint(4) NOT NULL,
    `F6` bigint(20) NOT NULL,
    `F7` bigint(20) NOT NULL,
    PRIMARY KEY (`F1`)
  ) ENGINE=InnoDB default charset=latin1;
  </code></pre>
  <p>The data file contains records of this form, which are separated by tab:</p>
  <pre><code>229733561174    44224449355443  0   0   0   55555557555000  12345678901
  </code></pre>
  <p>The import command :</p>
  <pre><code>mysql&gt; load data infile 'try.txt' INTO TABLE MYTABLE;
  </code></pre>
  <p>The warnings I get:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Level</th>
  <th>Code</th>
  <th>Message</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Warning</td>
  <td>1366</td>
  <td>Incorrect integer value: '229733561174' for column 'F1' at row 1</td>
  </tr>
  <tr>
  <td>Warning</td>
  <td>1366</td>
  <td>Incorrect integer value: '44224449355443' for column 'F2' at row 1</td>
  </tr>
  <tr>
  <td>Warning</td>
  <td>1366</td>
  <td>Incorrect integer value: '0  0       0       55555557555000 12345678901' for column 'F3' at row 1</td>
  </tr>
  <tr>
  <td>Warning</td>
  <td>1261</td>
  <td>Row 1 doesn't contain data for all columns</td>
  </tr>
  <tr>
  <td>Warning</td>
  <td>1261</td>
  <td>Row 1 doesn't contain data for all columns</td>
  </tr>
  <tr>
  <td>Warning</td>
  <td>1261</td>
  <td>Row 1 doesn't contain data for all columns</td>
  </tr>
  <tr>
  <td>Warning</td>
  <td>1261</td>
  <td>Row 1 doesn't contain data for all columns</td>
  </tr>
  </tbody>
  </table>
  </div>
  <pre><code>7 rows in set (0.00 sec)
  </code></pre>
  <p>I can't figure out why the values of the first two columns are <code>Incorrect integer value</code> and why the values of columns 3-7 are all treated as a single column.</p>
  <p>I tried changing the field separator to ',' (specifying it in the load data command), and still got the same warnings.</p>
  <p>The output table contains 0s in all columns (except for the optional column that gets NULL).</p>
  <p>Can someone please tell me what I'm doing wrong?</p>