Posted by "Rahul S. Johari" on 12/15/05 18:59

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

[Back to original message]