Re: 4 Digit ID with Leading Zeros

Ave, Primarily the application is for recycling some data. Things will be added by a client, shortly processed thereafter in-house, and removed. We won't be reaching the 10,000 records for this application. Thanks. On 12/15/05 11:00 AM, "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 Rahul S. Johari Coordinator, Internet & Administration Informed Marketing Services Inc. 251 River Street Troy, NY 12180 Tel: (518) 266-0909 x154 Fax: (518) 266-0909 Email: rahul@informed-sources.com http://www.informed-sources.com