RE: [PHP] Re: phpMyAdmin--resetting auto increments to 0

2006-04-16 Thread Jay Blanchard
[snip] I just get obsessive and thorough when testing and then I don't like stale data in my database - so I like to reset everything. It would be better to backup before testing and then restore. Resetting the AI just makes it the same as if you had. [/snip] I agree, that is why I truncate the

Re: [PHP] Re: phpMyAdmin--resetting auto increments to 0

2006-04-16 Thread Chuck Anderson
Jay Blanchard wrote: [snip] 2. Reset the auto_increment in Operations to 101 [/snip] This isn't another of those 'reseting the auto-increment' holy war questions where you use the AI number as an identifier for the record, is it? Nope. And I have no intention of taking it there.

RE: [PHP] Re: phpMyAdmin--resetting auto increments to 0

2006-04-16 Thread Jay Blanchard
[snip] >2. Reset the auto_increment in Operations to 101 [/snip] This isn't another of those 'reseting the auto-increment' holy war questions where you use the AI number as an identifier for the record, is it? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.ph

Re: [PHP] Re: phpMyAdmin--resetting auto increments to 0

2006-04-16 Thread Chuck Anderson
tedd wrote: At 3:01 PM -0600 4/16/06, Chuck Anderson wrote: tedd wrote: At 1:42 PM -0600 4/16/06, Chuck Anderson wrote: alex wrote: hi everyone i have delete a few entries in my database as they were entered for testing purposes and are no longer need (actuall

Re: [PHP] Re: phpMyAdmin--resetting auto increments to 0

2006-04-16 Thread tedd
At 3:01 PM -0600 4/16/06, Chuck Anderson wrote: tedd wrote: At 1:42 PM -0600 4/16/06, Chuck Anderson wrote: alex wrote: hi everyone i have delete a few entries in my database as they were entered for testing purposes and are no longer need (actually 102 entries)... and even thought t

Re: [PHP] Re: phpMyAdmin--resetting auto increments to 0

2006-04-16 Thread Chuck Anderson
tedd wrote: At 1:42 PM -0600 4/16/06, Chuck Anderson wrote: alex wrote: hi everyone i have delete a few entries in my database as they were entered for testing purposes and are no longer need (actually 102 entries)... and even thought that db is empty i noticed that when the next

[PHP] Re: phpMyAdmin--resetting auto increments to 0

2006-04-16 Thread tedd
At 1:42 PM -0600 4/16/06, Chuck Anderson wrote: alex wrote: hi everyone i have delete a few entries in my database as they were entered for testing purposes and are no longer need (actually 102 entries)... and even thought that db is empty i noticed that when the next entry went in the id n

[PHP] Re: phpMyAdmin--resetting auto increments to 0

2006-04-16 Thread Chuck Anderson
alex wrote: hi everyone i have delete a few entries in my database as they were entered for testing purposes and are no longer need (actually 102 entries)... and even thought that db is empty i noticed that when the next entry went in the id number went to 103 not 0 so i was wondering is it