Re[2]: [PHP-DB] padding an id field

Hello Raquel, Yes, but is it possible to append a code such as 'abc' along with the zerofill to create an id like 'abc000123' for the 123rd id record. /Merle Thursday, October 04, 2001, 1:13:59 PM, you wrote: RR> On Thu, 4 Oct 2001 09:47:16 -0300 RR> WebDev <WebDev@merlepittman.com> wrote: >> Is there anyway to pad an id field in MySQL? I have a table with RR> 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 RR> a >> code along with the auto incrementing part, such as ABC000223. RR> Now I >> wouldn't want the ABC pad to change but the 6 digits would still RR> auto >> incr as required. >> >> Is this possible without doing any field editing, exclusively with RR> a >> MySQL utility? >> >> thanks >> /Merle RR> When you define your auto-incrementing column, can't you specify RR> "ZEROFILL"? I believe it pads to the left with zeroes.