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 OKsometi
R TABLE table_name 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 PRO
serve you as a key to relate the data within
> application/database.
>
>
> Sincerely,
>
> Maxim Maletsky
>
> PHP Beginner
> www.phpbeginner.com
>
>
> > -Original Message-
> > From: ::: Flavio Bastos Amiel::::::> [mailto:[EMAIL PROTECTED]]
>
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 t
:> [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 04, 2002 2:28 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP] Re: May i?
>
> let's see if i can do it...
>
> i got a news site. everything was going OKsometimes i made few
> testing and then i delete the
let's see if i can do it...
i got a news site. everything was going OKsometimes i made few
testing and then i delete the content from the db... the problem is next:
the item "id" is an auto_increment element .. so the id's wasn't going
allrightbecause they where not true... sometimes
ask.
--
Best regards,
George Nicolae
IT Manager
___
PaginiWeb.com - Professional Web Design
www.PaginiWeb.com
"::: Flavio Bastos Amiel::>" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> May i ask for help about a subejct on MySQL here?
Man...you could have asked already and you might have got an answer from
others and "NO" from others...
I might answer you if your question is in the range of my knowledge.
"Zenith" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I know that, this is a newsgrou
8 matches
Mail list logo