|
|
Posted by "Rahul S. Johari" on 12/15/05 20:33
Ave,
I did actually think about a periodic reset, as I do something like that for
one other application, different issue.
Thanks.
On 12/15/05 1:24 PM, "tg-php@gryffyndevelopment.com"
<tg-php@gryffyndevelopment.com> wrote:
> If it's really a temporary table, then you can probably reset the auto
> increment counter periodically so you'll never hit 9999.
>
> If it doesn't have to be 4 digits, that you just want it padded out with
> zeros, you can have the numbers in the databse be 1, 2, 3, 4 (regular, no
> padding) and just use PHP to pad the numbers for display purposes too.
>
> Just some random thoughts.
>
> -TG
>
> = = = Original message = = =
>
> Ave,
>
> Now that is an interesting perception. I didn't think about that. Well I can
> always change it to five or six. Let me re-assess this with the concerned
> person in the department and see what the scenario is like. I'll have to
> check the fluency of incoming data and expectancy of reaching the 10,000th
> mark.
>
> Thanks a bunch.
>
>
>
> On 12/15/05 12:38 PM, "Jim Moseby" <jmoseby@nrbindustries.com> wrote:
>
>> Yes, but as I understand it, MySQL will continue to increment as new
>> records are added, so it would be possible that you have only one record
>> in the table, but not be able to add another because of the 4 digit
>> restriction. If this is the case, you will only be able to have 10,000
>> ADDs, not 10,000 records. Just something to be aware of.
>>
>> 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
>
>
> ___________________________________________________________
> Sent by ePrompter, the premier email notification software.
> Free download at http://www.ePrompter.com.
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]
|