at results did you get?
>
>
> -Original Message-
> From: Claudiu [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 12, 2002 8:51 AM
> To: [EMAIL PROTECTED]
> Subject: RE: [PHP] reset auto_increment field mysql
>
>
> I wish it was that simple...
> No.. It d
It worked for me.
What results did you get?
-Original Message-
From: Claudiu [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 12, 2002 8:51 AM
To: [EMAIL PROTECTED]
Subject: RE: [PHP] reset auto_increment field mysql
I wish it was that simple...
No.. It doesn't work this way..
How about:
ALTER table auto_increment=0
> -Original Message-
> From: Claudiu [mailto:[EMAIL PROTECTED]]
> 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
TECTED]
> Subject: [PHP] reset auto_increment field mysql
>
>
> I have a mysql table which contains an id field which is set to
> auto_increment.
> I have a script which empties this database at regular intervals.
> My problem is that the auto_increment field won't reset to
your query is: DELETE FROM mytable;
-Original Message-
From: Claudiu [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 12, 2002 5:09 AM
To: [EMAIL PROTECTED]
Subject: [PHP] reset auto_increment field mysql
I have a mysql table which contains an id field which is set to
auto_increment
I have a mysql table which contains an id field which is set to
auto_increment.
I have a script which empties this database at regular intervals.
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.
How can i so
6 matches
Mail list logo
