monty, i found that if you do the command DELETE FROM table
(with no WHERE clause) it deletes everything, and resets Beau // -----Original Message----- // From: Monty [mailto:[EMAIL PROTECTED]] // Sent: Thursday, 25 July 2002 1:34 PM // To: [EMAIL PROTECTED] // Subject: [PHP-DB] Resetting MySQL Auto_Index - How? // // // Is there a way to re-set the internal counter that // automatically increments // "auto_increment" fields? While testing an app, I added a lot // of test records // that I've deleted, so, I'd like to reset the counter back to // the beginning // now. // // Thanks. // // // -- // PHP Database Mailing List (http://www.php.net/) // To unsubscribe, visit: http://www.php.net/unsub.php // -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php