title: Update MySQL Table using CSV file
body: <p>my Current MySQL table <code>employee_data</code> has 13k rows with 17 columns. The data in the table came from a CSV file <code>Employees.csv</code>. after importing my csv data I added a new column 'password' (so its not in the csv file) Password is edited and accessed via a web portal. I now have an updated csv file and I want to update my main table with that data but I don't want to lose my password info. </p>
  
  <p>Should I import my new CSV file into a temp table in my database and some how compare them?  I am not sure where to start and I am open to recommendations. </p>
  
  <p><strong>I am now realizing  I should have kept my password info in a separate table. Doh!</strong> </p>
  
  <p>I guess I could created a php file that compares each row based on the employee_id field but with 13k rows I am afraid it would time out possibly. </p>