Re: Re[2]: [PHP-DB] padding an id field
| From: | Raquel Rice | Date: | Thu, 04 Oct 2001 18:19:57 +0000 |
| Subject: | Re: Re[2]: [PHP-DB] padding an id field | ||
| References: | 1 2 3 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-13005@lists.php.net to get a copy of this message | ||
On Thu, 4 Oct 2001 14:17:22 -0300
WebDev <WebDev@merlepittman.com> 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 append a code such as 'abc' along with
the
> zerofill to create an id like 'abc000123' for the 123rd id record.
>
> /Merle
>
I don't believe that's a possibility. However, if I were doing it
myself, I would have two columns ... one that contained the 'abc'
identifier (or whatever) and the second which contained the
auto-incremented ID. Then when I retrieved the full ID, I would do
it using ...
SELECT concat(first_id,auto_id) AS full_id FROM id_table ORDER BY
full_id;
--
Raquel
============================================================
Don't be afraid of opposition. Remember, a kite rises against ...
not with ... the wind.
--Hamilton Mabie