RE: [PHP] 4 Digit ID with Leading Zeros
| From: | Jim Moseby | Date: | Thu, 15 Dec 2005 16:00:42 +0000 |
| Subject: | RE: [PHP] 4 Digit ID with Leading Zeros | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-227476@lists.php.net to get a copy of this message | ||
>
> 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