Re: 4 Digit ID with Leading Zeros
| From: | Anas Mughal | Date: | Thu, 15 Dec 2005 16:55:22 +0000 |
| Subject: | Re: 4 Digit ID with Leading Zeros | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-227477@lists.php.net to get a copy of this message | ||
The suggestions made are all great.
However, I have a problem understanding the requirement of having the Id in
the database matchup with the filename. (You could always append the when
binding the database Id with the filename.)
Please elaborate on your requirements.
Thanks.
On 12/15/05, Jim Moseby <JMoseby@nrbindustries.com> wrote:
>
> >
> > I'm looking into the ZEROFILL option now. Didn't know about
> > it before but it
> > looks promising and probably is my solution. I'll get back.
>
> Obviously, with a 4 digit id, you will only be able to store 10,000
> records.
> If I recall correctly, MySQL auto-increment fields will not reuse id's
> when
> they are deleted. So, you will need to take that into consideration when
> (if) you reach the 9,999th record.
>
> JM
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
Anas Mughal