title: MYSQL import: port a big list of names into mysql table column. An easy way?
body: <p>I have a txt file with tons of complex names I want to insert into my sql table named cred_insurances. The table is currently blank. Each line should be one record and the name should be in the column called ProviderName. My text file is like this:</p>
  
  <pre><code>Alabama Medicaid
  Alaska Medicaid
  Arizona Medicaid (AHCCCS)
  Arkansas Medicaid
  California Medicaid
  Colorado Medicaid
  Colorado Medicare
  Connecticut Medicaid
  Delaware Medicaid
  Florida Medicaid
  ETC...BLAH BLAH BLAH
  </code></pre>
  
  <p>I was thinking of doing some sort of replace function on the text file that might be able to put the proper sql syntax before and after each name so that I could paste it all at the prompt, but that seems quite much. There must be an easier way to do this.</p>
  
  <p>I think that a single command for each line would be thus:</p>
  
  <pre><code>INSERT INTO cred_insurances (ProviderName) values ("Alabama Medicaid");
  </code></pre>