[PHP-DB] padding an id field

2001-10-04 Thread WebDev
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

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

2001-10-04 Thread Raquel Rice
On Thu, 4 Oct 2001 14:17:22 -0300 WebDev [EMAIL PROTECTED] wrote: Thursday, October 04, 2001, 1:13:59 PM, you wrote: RR When you define your auto-incrementing column, can't you specify RR ZEROFILL? I believe it pads to the left with zeroes. Hello Raquel, Yes, but is it possible to