padding an id field

From: Date: Thu, 04 Oct 2001 12:47:16 +0000
Subject: padding an id field
Groups: php.db 
Request: Send a blank email to php-db+get-12994@lists.php.net to get a copy of this message
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? thanks /Merle

« previous php.db (#12994) next »