Re: An Idea

[Paul DuBois]

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