Re: [PHP-DB] Resetting MySQL Auto_Index - How?
On Thursday 25 July 2002 13:34, Monty wrote: 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. Yes, it's documented in the mysql manual. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Nudists are people who wear one-button suits. */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Resetting MySQL Auto_Index - How?
Do you know which page it's on? I've searched the MySQL online help for 40 minutes and can't find anything, which is why I asked here. From: [EMAIL PROTECTED] (Jason Wong) Organization: Gremlins Associates Reply-To: [EMAIL PROTECTED] Newsgroups: php.db Date: Thu, 25 Jul 2002 14:41:49 +0800 To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Resetting MySQL Auto_Index - How? On Thursday 25 July 2002 13:34, Monty wrote: 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. Yes, it's documented in the mysql manual. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Resetting MySQL Auto_Index - How?
On Thursday 25 July 2002 15:03, Monty wrote: Do you know which page it's on? I've searched the MySQL online help for 40 minutes and can't find anything, Sorry I wouldn't know. which is why I asked here. But really you should be asking on the MySQL list, hopefully that's where the MySQL experts hangout. Have you tried google? I'm not sure why you want to reset the 'counter' anyway. It doesn't affect the working of your application. If you're desperate, drop the table and recreate it, that should definitely reset the counter. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Exceptions prove the rule, and wreck the budget. -- Miller */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[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
RE: [PHP-DB] Resetting MySQL Auto_Index - How?
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