title: Importing text file data into rows in MySQL
body: <p>I have a text file which contain rows in this format:</p>
  
  <p>com1,System Access,MinimumPasswordAge,1 <br>
  com1,System Access,MaximumPasswordAge,42<br>
  com1,System Access,MinimumPasswordLength,7<br></p>
  
  <p>I wish to import this data in 3 seperate rows in the following format:</p>
  
  <p>"com1" in <code>ID</code> column, <br>"System Access" in <code>Audit_Type</code> column, <br>"MinimumPasswordAge" in <code>System_Setting</code> column, and <br>"1" in <code>Actual_Value</code> column.</p>
  
  <p>Im using MySQL Query Browser in Windows 7 SP1.</p>