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 have a status running if
the script is processing that particular user or finished when that user is
done.
The problem is, when I am done with all users in the table I want to
remove them and "repopulate" the table with a new set of users froma
different server. But when I remove the users and add the new users the
auto_incremented id field does not get reset to 0, it picks off where the
other users id left off.
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?
Thanks for the help
-chad
--
Chad Kellerman
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
