Posted by David Grant on 12/15/05 17:17

Rahul,

Rahul S. Johari wrote:
> The 4 Digit ID (beginning from 0001) will be used in two places:
> (a) It will be the ID for the record in the mySQL table, instead of the
> usual ID that we create in mySQL. It will be a Primary Key, Not Null,
> Auto_Increment

Adding ZEROFILL to that definition might be what you're after.

Cheers,

David
--
David Grant
http://www.grant.org.uk/

[Back to original message]