title: updating the column of a table with different values
body: <p>I have a table called person there are about 3 million rows</p>
  
  <p>I have added a column called company_type_id whose default value is 0</p>
  
  <p>now i want to update the value of  company_type_id to 1</p>
  
  <p>where person_id from 1 to 212465
  and value of company_type_id to 8 where person_id from 256465 to 656464</p>
  
  <p>how can i do this</p>
  
  <p>I am using mysql</p>