ID in mysql? - 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: ID in mysql? (/showthread.php?tid=429976)

---

ID in mysql? - Fernado Samuel - 12.04.2013

Removed

---

Re: ID in mysql? - MP2 - 12.04.2013

Are you referring to an auto incrementing primary key?

---

Re: ID in mysql? - Fernado Samuel - 12.04.2013

Removed

---

Re: ID in mysql? - RajatPawar - 12.04.2013

He means something like the AUTO_INCREMENT primary key which is a unique number assigned to every NEW entry of a row in the table.

---

Re: ID in mysql? - Fernado Samuel - 12.04.2013

Removed

---

Re: ID in mysql? - Vince - 12.04.2013

1. Ids are used because numerical searches are faster than string searches, and because they are always unique. They also provide a good reference to and from the table when working with relations.
2. Yes. auto_increment fields are a MySQL server feature, not a client feature.
3. No. See above.

---

Re: ID in mysql? - Fernado Samuel - 12.04.2013

Removed

---

Re: ID in mysql? - ReneG - 12.04.2013

What?

---

Re: ID in mysql? - zT KiNgKoNg - 12.04.2013

If you want ID's for each players thats registers on your server just add ID with AI on it, I don't see the point in havings ID's you're better off with registration dates

---