title: MySQL - autoincrement to guid
body: <p>I have a table with an auto-increment ID field as shown below.</p>
  
  <pre>
  +------------+-------------------------------------+
  | company_id | name                                |
  +------------+-------------------------------------+
  |          1 | International Client                |
  |          2 | Oracle                              |
  |          3 | test                                |
  |          4 | testabc                             |
  |          5 | testdef                             |
  |          6 | abcd                                |
  +------------+-------------------------------------+
  
  </pre>
  
  <p>I want to update the ID column to be a GUID using the <pre>uuid()</pre> function. </p>
  
  <p>Additionally, how do I update the foreign key references to the correct GUID?</p>