[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 AI to 0. You would then have to re-populate the table. HTH! Jay mysql, sql, query --------------------------------------------------------------------- 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
