Re: Resetting MySQL Auto_Index - How?
| From: | Monty | Date: | Thu, 25 Jul 2002 07:03:27 +0000 |
| Subject: | Re: Resetting MySQL Auto_Index - How? | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-20774@lists.php.net to get a copy of this message | ||
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: phplist@gremlins.com.hk (Jason Wong)
> Organization: Gremlins Associates
> Reply-To: php-db@lists.php.net
> Newsgroups: php.db
> Date: Thu, 25 Jul 2002 14:41:49 +0800
> To: php-db@lists.php.net
> 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 *
>