SQLite question - 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: SQLite question (/showthread.php?tid=662144)

---

SQLite question - SapMan - 24.12.2018

Is it necessary to use these things ( INSERT INTO `PLAYERS` ( `NAME` ), %q )?

I mean those quotes " `` " and " %q " instead of " %s "

---

Re: SQLite question - SyS - 24.12.2018

If a column has same name as a reserved keyword in SQL or contains a space, you need to quote it using back ticks ( ` ).

%q escapes special characters in order to avoid SQL injection

---

Re: SQLite question - SapMan - 24.12.2018

Oh, it's fine. But, I do not understand the second, what do you mean by "special characters"? If it's the name, ip, password, how would you do it in this case?

---