title: Adding tables in mysql
body: <p>I've been trying to add this table but all data is embedded in one column in the SQL matrix.
  For example:</p>
  
  <pre><code>mysql&gt; describe genomas;
  +--------+--------------+------+-----+---------+-------+
  | Field  | Type         | Null | Key | Default | Extra |
  +--------+--------------+------+-----+---------+-------+
  | Object | varchar(255) | NO   |     | NULL    |       |
  | GOID   | varchar(255) | NO   | MUL | NULL    |       |
  +--------+--------------+------+-----+---------+-------+
  2 rows in set (0.09 sec)
  </code></pre>
  
  <p>the data I want to upload is in a .txt file. 
  then I upload buuut..</p>
  
  <pre><code>mysql&gt; LOAD DATA LOCAL INFILE 'GOhumanbegin.txt' INTO TABLE genomas FIELDS TERMINATED BY '\t';
  Query OK, 499486 rows affected, 65535 warnings (20.20 sec)
  Records: 499486  Deleted: 0  Skipped: 0  Warnings: 499486
  </code></pre>
  
  <p>(&lt;-IT IS SHOWING WARNINGS...but why?)</p>
  
  <pre><code>mysql&gt; SELECT Object, GOID  FROM genomas LIMIT 10;
  </code></pre>
  
  <p>What i got:</p>
  
  <pre><code>| Object                | GOID |
  +-----------------------+------+
  | A0A024RBG1 GO:0003723 |      |
  | A0A024RBG1 GO:0005829 |      |
  | A0A024RBG1 GO:0008486 |      |
  | A0A024RBG1 GO:0046872 |      |
  | A0A024RBG1 GO:0052840 |      |
  | A0A024RBG1 GO:0052842 |      |
  | A0A075B6H7 GO:0002250 |      |
  | A0A075B6H7 GO:0005886 |      |
  | A0A075B6H7 GO:0019814 |      |
  | A0A075B6H8 GO:0002250 |      |
  </code></pre>
  
  <p>What I expected:</p>
  
  <pre><code>| Object                | GOID           |
  +-----------------------+----------------+
  | A0A024RBG1            | GO:0003723     |
  | A0A024RBG1            | GO:0005829     |
  | A0A024RBG1            |  GO:0008486    |
  | A0A024RBG1            |  GO:0046872    |
  | A0A024RBG1            |  GO:0052840    |
  | A0A024RBG1            |  GO:0052842    |
  | A0A075B6H7            |  GO:0002250    |
  | A0A075B6H7            |  GO:0005886    |
  | A0A075B6H7            |  GO:0019814    |
  | A0A075B6H8            |  GO:0002250    |
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/u1MbT.png" rel="nofollow noreferrer">enter image description here</a></p>