Re: [PHP-DB] Resetting MySQL Auto_Index - How?

2002-07-25 Thread Jason Wong
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

Re: [PHP-DB] Resetting MySQL Auto_Index - How?

2002-07-25 Thread Monty
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

Re: [PHP-DB] Resetting MySQL Auto_Index - How?

2002-07-25 Thread Jason Wong
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

[PHP-DB] Resetting MySQL Auto_Index - How?

2002-07-24 Thread Monty
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

RE: [PHP-DB] Resetting MySQL Auto_Index - How?

2002-07-24 Thread Beau Lebens
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