[audriuxxx]

Hi,


I want to ask about AUTO_INCREMENT.

I have 5 accounts now, and id is with auto_increment.

1 -
2 -
3 -
4 -
5 -

But if i delete for ex: 4 user, then why when i create new user him id will be 6? how to do if i delete user, then new user go to him place?

[SuperViper]

That's how MySQL auto increment works and it doesn't matter if there's an empty ID.

[audriuxxx]

Or maybe impossible to ORDER them? like if id is now:

5
8
9
100
5
10

Make them with query

1
2
3
4
5
6