SA-MP Forums Archive
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: MySQL (/showthread.php?tid=624382)



MySQL - GoldenLion - 15.12.2016

Hi, are these `` important in MySQL queries? I know that the queries work with and without them. What are they for? I tried googling, but I couldn't find anything or I just didn't understand.


Re: MySQL - Vince - 15.12.2016

They are used to explicitly tell the interpreter that the quoted value is an identifier, not a reserved word. In other words, if you have a table or column name that appears in this list (words marked with ®) then you should add those backticks. The alternate and better option, however, is to not use table or column names that are or could become reserved words.


Re: MySQL - GoldenLion - 15.12.2016

Quote:
Originally Posted by Vince
Посмотреть сообщение
They are used to explicitly tell the interpreter that the quoted value is an identifier, not a reserved word. In other words, if you have a table or column name that appears in this list (words marked with ®) then you should add those backticks. The alternate and better option, however, is to not use table or column names that are or could become reserved words.
OK, I got it, thank you.