RE: [PHP] reset auto_increment field mysql
| From: | Matt Schroebel | Date: | Tue, 12 Mar 2002 15:14:11 +0000 |
| Subject: | RE: [PHP] reset auto_increment field mysql | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-88210@lists.php.net to get a copy of this message | ||
How about:
ALTER table auto_increment=0
> -----Original Message-----
> From: Claudiu [mailto:yonix@1a.ro]
> I wish it was that simple...
> No.. It doesn't work this way...
>
> On Tue, 12 Mar 2002, Rick Emery wrote:
>
> > your query is: DELETE FROM mytable;
> >
> > -----Original Message-----
> > From: Claudiu [mailto:yonix@1a.ro]
> > My problem is that the auto_increment field won't reset to 0 after
> > deleting all of tha data, but continue incrementing from
> where it left.