title: How to change ID in mysql
body: <p>Say I have a table Business in mySQL.</p>
  
  <p>The ID in each "business" is a function of title and location. It makes programming much more easy.</p>
  
  <p>I also often merge 2 identical businesses, etc.</p>
  
  <p>Say one day the title of the business change and I want to change the ID. An operation that I will rarely done.</p>
  
  <p>Many other tables point to that business.</p>
  
  <p>So what should I do?</p>
  
  <p>Should I create the new ID and then change all relationship that points to the original business to the new ID?</p>
  
  <p>Is there a mysql command that'll do this faster?</p>
  
  <p>Any sample vb.net code?</p>