You can reset the id with this command:
ALTER TABLE $tablename AUTO_INCREMENT = 242
: : Flavio Bastos Amiel: : : : : : INVALID_ADDRESS_IN_GROUP@.SYNTAX-ERROR.,
Flavio Bastos Amiel:: wrote:let's see if i can do it...
i got a news site. everything was going
Why do you need it anyway?
auto_increment is a mySQL functionality to (listen this carefully) KEEP
UNICITY WITHIN A TABLE. This is what they are needed for. I agree - it
would look prettier having them even sequential, but that is behind the
real point and it is not a problem.
You should make
On Tue, Sep 03, 2002 at 08:27:37PM -0400, ::: Flavio Bastos Amiel:: wrote:
i tried to delete that cell (id) and then i recreate it. thinking the id was
going to count it all over and make the item id TRUE.but it wasn't like
that, the new id was counting since the last id then if the
well... yes, then maybe i made a mistake there was data related to
the id . then i delete that row and the data that was related to the
comments are gone away, because the row id has changedso i would have to
put then manually again
Flavio Bastos Amiel
Maxim Maletsky
AUTO_INCREMENT = 1;
And that's it... it will restore the counting back to where it was left.
HTH, C.
-Original Message-
From: ::: Flavio Bastos Amiel:: [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 03, 2002 10:09 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP] Re: May i?
well
5 matches
Mail list logo