Hi. I used to wonder that myself too. Now (after lots of auto_increment fields I've done) I know that a sequential order is just pretty but useless 'cause MySQL won't give you a maximum fields allowed.
The solution is pretty easy. Just make an SQL query like this: SQL> ALTER 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 PROTECTED] > Subject: Re: [PHP] Re: May i? > > 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 changed....so i would have > to > put then manually again.... > > Flavio Bastos Amiel > > > "Maxim Maletsky" <[EMAIL PROTECTED]> wrote in message > 000c01c23b50$050fcfe0$1113fe17@dominanta">news:000c01c23b50$050fcfe0$1113fe17@dominanta... > > > > 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 your application independent from "id" value - "id" > > should only 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]] > > > 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 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" <[EMAIL PROTECTED]> wrote in message > > > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > > > 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? > > > > > > > > > > thanks, > > > > > Flavio Bastos Amiel > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > PHP General Mailing List (http://www.php.net/) > > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
