title: insert/update mysql column based on existing data
body: <p>I'm updating an existing table by adding data into an existing column.</p>
  
  <p>I have already have an output of the data to be inserted, but due to the amount of records, i'm looking for the best way to insert this into my table without having to manually write to each line of sql.</p>
  
  <p>Here's my sql (partial) i want to insert into </p>
  
  <pre><code>INSERT INTO `tbl_user_variables_dobRE` (`user_id`, `value`) VALUES
  (150, '1959-11-02'),
  (151, '1948-04-20'),
  (152, '1961-06-18'),
  </code></pre>
  
  <p>And this is the table i want to insert it into</p>
  
  <pre><code>id         | 7
  username   | guestinvite
  password   | BLANK
  forname    | forname
  surname    | surname
  email      | guestinvite@test.com
  address_id | 286
  type_id    | 4
  dob        | 0000-00-00
  plusGuest  | 0
  update     | 2016-02-16 11:54:36
  created    | 2016-04-04 17:03:12
  </code></pre>
  
  <p>So i want to insert the second item into the 'dob' column where first item = id</p>
  
  <p>Is there anyway to do this programmatically or do i have to write WHERE &amp; OR statements for every line?</p>