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@xxxxxxxxxxxxxxxxxxxxxx" <tg-php@xxxxxxxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxxx > 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@xxxxxxxxxxxxxxxxxxxx http://www.informed-sources.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
