MySQL saving "ID" to the table - 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 saving "ID" to the table (/showthread.php?tid=493907)

---

MySQL saving "ID" to the table - Riwerry - 10.02.2014

Why is newbienoob saving to mysql table variable ID in his tut? For what is it needed?

---

Re: MySQL saving "ID" to the table - Vince - 10.02.2014

Searching through numbers is much faster than searching through text. It also comes into play when creating relations to different tables (yes, MySQL is a relational database!). You want to avoid duplicate data at all costs. Duplicating the name into different tables is a terrible practice. Other than that, the name may be changed. The ID won't.

---

Re: MySQL saving "ID" to the table - Riwerry - 10.02.2014

I was just wondering if I cant just use check for names but now I know through numbers its faster.

---