Reseting auto_incremented id's

2002-06-11 Thread chad kellerman
Hello everyone, I have a perl script that talks to a mysql database. What I am doing is grabbing a bunch of users of a server and putting them into a table. Then as the script runs on each user I am giving the status of the script as associated with the user. For example user abc will

RE: Reseting auto_incremented id's

2002-06-11 Thread Jay Blanchard
[snip] Is there any way to reset this id field to 0 when I am done processing the users? I read this can be accomplished by an myisamchk. But I do not want to have system calls thru my script? Is there any other way to do this? [/snip] TRUNCATE tablename Empties the table and resets the