Is there anyway to pad an id field in MySQL?  I have a table with a PK
field (id).  This field is auto incrementing a 6 digit number ie.
000223.  Is there anyway to pad this id so that it is padded with a
code along with the auto incrementing part, such as ABC000223.  Now I
wouldn't want the ABC pad to change but the 6 digits would still auto
incr as required.

Is this possible without doing any field editing, exclusively with a
MySQL utility?


PHP Database Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to