title: Can I move a column from one mysql table to another, and replace the original column with the new id's form the new table?
body: <p>My project is growing and need to expand from a single table to two. </p>
  
  <p>I have posts, and each post has an author. Currently the author is just a column in posts, but I have made an new table called authors. I would like to populate the new table with all unique instances of authors <strong>and</strong> replace the author values in the posts table with the new author ids. </p>
  
  <p>Is there some sql magic that can help me do this? My post table is 30k entries so I would like to avoid doing it manually  ;)</p>
  
  <p>thanks!</p>