<div>
Since the relationship table is a bit new to me, could you either detail a bit more or point me to an explanation?
</div>


<div>
<div class="content wysiwyg-content">
I have a database that manages our communication with clients.<br />
<br />
When I built it, i setup the group ID field to just auto-increment from 1. &nbsp;So my groupIDs are 1, 2, 3, ... etc.<br />
<br />
Now that we've grown, I want to use an ID that is less &quot;Guessable&quot;. &nbsp;I'd like to change it to some random variation of an MD5 field. &nbsp;Probably take the first 5 characters or something like that.<br />
<br />
I can easily change the group IDs and start inserting new from here forward. &nbsp;<br />
<br />
However, my question is about updating the info records that are currently tied to the old client ID. &nbsp;What would be the best practice for that? &nbsp;Perhaps create an Archive Client ID field in the table to keep the connection or run an UPDATE command of the field to change ids from old to new?<br />
<br />
Ideas?
</div>
</div>


I have a database that manages our communication with clients.

When I built it, i setup the group ID field to just auto-increment from 1.  So my groupIDs are 1, 2, 3, ... etc.

Now that we've grown, I want to use an ID that is less "Guessable".  I'd like to change it to some random variation of an MD5 field.  Probably take the first 5 characters or something like that.

I can easily change the group IDs and start inserting new from here forward.  

However, my question is about updating the info records that are currently tied to the old client ID.  What would be the best practice for that?  Perhaps create an Archive Client ID field in the table to keep the connection or run an UPDATE command of the field to change ids from old to new?

Ideas?

Change Database Information on multiple tables best practice

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.