title: how to import a formatted text file into mysql database
body: <p>sing the Mac terminal, how could you populate a mysql database when the text file has a format like this.</p>
  
  <pre><code>00000,1284
  00001,2081
  </code></pre>
  
  <p>I have created the database table to reflect that data however I am not sure on how to import a text file with this type of format..</p>
  
  <p>This is what I am trying to use right now but its not working</p>
  
  <pre><code>LOAD DATA INFILE 'Developer/Shared Files/NIS.txt INTO TABLE nisC FIRLDS TERMINATED BY ',';
  </code></pre>