title: How to extract a column of data and replace with foreign key?
body: <p>How do you extract a <code>column (varchar, allows null)</code> of data into a new table and replace it with a foreign key?</p>
  
  <p>Steps as I know them:</p>
  
  <blockquote>
    <ol>
    <li>Create a new table with an incrementing PK column and data varchar
    column. </li>
    <li>Use <a href="http://www.w3schools.com/sql/sql_insert_into_select.asp" rel="nofollow">insert-into-select</a> to copy the data into the new
    table. </li>
    <li>Update/add a foreign key column in the original table???</li>
    </ol>
  </blockquote>
  
  <p>How would I make the foreign key, step 3?</p>