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
> 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
> 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

Don't be afraid of opposition. Remember, a kite rises against ...
not with ... the wind.
  --Hamilton Mabie


PHP Database Mailing List (http://www.php.net/)
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