mysql update. - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: mysql update. (/showthread.php?tid=446330)

---

mysql update. - audriuxxx - 25.06.2013

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?

---

Re: mysql update. - SuperViper - 25.06.2013

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

---

Re: mysql update. - audriuxxx - 25.06.2013

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

---