SA-MP Forums Archive
[MySQL] Query error (Another) - 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] Query error (Another) (/showthread.php?tid=377356)



[MySQL] Primary Key (Account ID) problems - vIBIENNYx - 13.09.2012

Whenever I need to delete an account for whatever reason, it messes up the MySQL key information and causes the register system to crash, how can I use MySQL to fix the primary key (Account ID) to suit the deleted account?

For example, I have 15 accounts, and I delete the nineth.

I want ten to become nine, eleven to become ten, etc.

How can I do this?


Re: [MySQL] Query error (Another) - vIBIENNYx - 13.09.2012

Actually dont ignore, new problem.