List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:December 29 2002 4:02pm
Subject:Re: An Idea
View as plain text  
At 11:26 +0100 12/29/02, Adam Wi´ckowski wrote:
>Hello,
>I had a problem few days ago. I'm doing my questbook, and I were thinking
>what would hapen if I delete some row. Now I know, nothing. I had one column
>ID (auto_increment) in my table. I wanted it to be one by one

Why?

>  even after
>deleting, so I changed it by myself. But then (after deleting the last ID
>was 17, and before 32), next ID was 33, not 18. Is there any function, which
>can change it? If not, mayby you'll try to do something like that. It's
>right, I can do it by myself not using auto_increment, and giving the ID
>number MAX(ID)+1, but if there is such function it would be realy fine.
>Greatings,
>MySQL user
>
>Adam Wi´ckowski
>GG# :1257924

Thread
An IdeaUnknown Sender29 Dec
  • Re: An IdeaBenjamin Pflugmann29 Dec
  • re: An IdeaEgor Egorov29 Dec
  • Re: An IdeaPaul DuBois29 Dec
    • RE: An IdeaCal Evans29 Dec
      • Re: An IdeaiConnect \(Berlin\) Stefan Hinz29 Dec
        • RE: An IdeaPeter Lovatt30 Dec
          • RE: An IdeaJamesD30 Dec
            • RE: An IdeaPeter Lovatt30 Dec
            • RE: An IdeaCal Evans30 Dec
            • RE: An Idea (really: MySQL and Perl for the Web)Paul DuBois30 Dec
              • RE: An Idea (really: MySQL and Perl for the Web)JamesD30 Dec
          • Re: An IdeaiConnect \(Berlin\) Stefan Hinz30 Dec
            • Re: An IdeaDavid T-G31 Dec
              • RE: An IdeaPeter Lovatt31 Dec
          • Re: An IdeaiConnect \(Berlin\) Stefan Hinz31 Dec
            • Re: An IdeaDavid T-G1 Jan
              • RE: An IdeaJamesD1 Jan
                • Re: An IdeaR. Hannes Niedner1 Jan
                  • Re: An IdeaMichael T. Babcock2 Jan
                • Re: An IdeaiConnect \(Berlin\) Stefan Hinz1 Jan
                  • RE: An IdeaJamesD1 Jan
          • Re: An IdeaiConnect \(Berlin\) Stefan Hinz1 Jan
            • Re: FAQ hosting site (was "Re: An Idea")David T-G1 Jan
          • Re: FAQ hosting site (was "Re: An Idea")iConnect \(Berlin\) Stefan Hinz1 Jan
            • RE: FAQ hosting site (was "Re: An Idea")B. van Ouwerkerk1 Jan
            • RE: FAQ hosting site (was "Re: An Idea")Peter Lovatt2 Jan
              • RE: FAQ hosting site (was "Re: An Idea")mnbv2 Jan
                • RE: FAQ hosting site (was "Re: An Idea")Peter Lovatt2 Jan
                  • RE: FAQ hosting site (was "Re: An Idea")Dan Goodes2 Jan
                  • Re: FAQ hosting site (was "Re: An Idea")Bruce Lewis2 Jan
              • Re: FAQ hosting site (was "Re: An Idea")Jeremy Zawodny2 Jan
                • RE: FAQ hosting site (was "Re: An Idea")Peter Lovatt2 Jan
              • Re: FAQ hosting siteDavid T-G2 Jan
            • Re: FAQ hosting site (was "Re: An Idea")Bruce Lewis2 Jan
              • Re: FAQ hosting siteDavid T-G2 Jan
                • Re: FAQ hosting site [FAQTS.COM]Michael T. Babcock2 Jan
            • Re: FAQ hosting siteDavid T-G2 Jan
            • Re: FAQ hosting site [FAQTS.COM]indrek siitan3 Jan
  • Re: An IdeaMichael She29 Dec
    • Re: An Ideaharm29 Dec