title: MySQL Load Data Infile auto incremented ID value
body: <p>I want to insert an ID column to my table and get data of this table from a text file.
  For example my text file is like that:</p>
  
  <pre><code>12    1212    4989    121
  121   23      123     110
  789   99      234     544
  ...
  </code></pre>
  
  <p>and it has approximately 20M rows. I want to insert this data to a table and include an auto incremented ID value column for it. I will use "Load data infile", but I want to create my table as indicated below:</p>
  
  <pre><code>id    a     b       c       d
  ---   ---   ---     ---     ---  
  1    12    1212    4989    121
  2    121   23      123     110
  3    789   99      234     544
  ...
  </code></pre>
  
  <p>How can I create this kind of table using mysql (workbench)</p>