Re: Re: May i?

well, the query wasn't sucessfull for me i'm using MySQL 3.23.37 :s is what my hosting serves..... well..... i woul try doing something else...... think it's time to let this discussion apart, :) Thanks everybody for the help! Flavio Bastos Amiel "Manuel" <manuel@ochoa-usa.com> wrote in message news:20020804171944.18522.qmail@web20707.mail.yahoo.com... > > 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 OK....sometimes 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 > allright....because they where not true... sometimes they make jumps like id > #25 and the id #30 (because of the testing i've done and then delete) > > 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 last id was > 100, the new id was counting from 100 to 200 .... do i explain myself?... > does anyone have an answer to this problem (PLEASE Dont tell me i have to do > i manually!! ) > > thanks, > Flavio Bastos Amiel > > > > > > "George Nicolae" wrote in message > news:20020804001037.31489.qmail@pb1.pair.com... > > ask. > > > > -- > > > > > > Best regards, > > George Nicolae > > IT Manager > > ___________________ > > PaginiWeb.com - Professional Web Design > > www.PaginiWeb.com > > > > > > "::: Flavio Bastos Amiel::::::>" wrote in message > > news:20020803224811.95593.qmail@pb1.pair.com... > > > May i ask for help about a subejct on MySQL here? > > > > > > thanks, > > > Flavio Bastos Amiel > > > > > > > > > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > ~ Manuel Ochoa ~ > Seven days is too long to wait for a gun! > > > > --------------------------------- > Do You Yahoo!? > Yahoo! Health - Feel better, live better