title: mysql bulk insert a text file
body: <p>I am having plain text file and i would like to move the content of that text file in to mysql table line by line can any one help me as it is not a csv file how can i achieve this</p>
  
  <p>I designed my db as follows</p>
  
  <pre><code>RowID, int(11), NO, PRI,auto_increment
  Text, varchar(94) // Here i have to insert line by line
  RecordType, varchar(50)
  </code></pre>
  
  <p>Content sample</p>
  
  <pre><code>123456789007
  545654665654654
  6344534534543534534
  786775645654654646
  8456546456456546
  9078565656546546546456456456
  </code></pre>