What is the different between `Users` and Users MySQL

What is the different between `Users` and Users 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: What is the different between `Users` and Users MySQL (/showthread.php?tid=533000)

What is the different between `Users` and Users MySQL - SPA - 21.08.2014

Код:

Hello, I'v a question what is the different between :
        format(query, sizeof(query), "UPDATE `Users` SET Money = %d WHERE Name= '%s'",money,pName(playerid));
        mysql_query(query);
        
        format(query, sizeof(query), "UPDATE Users SET Admin = %d WHERE Name= '%s'",pInfo[playerid][Admin],pName(playerid));
        mysql_query(query);

Re: What is the different between `Users` and Users MySQL - ball - 21.08.2014

There is no difference - both codes will do the same thing.

Re: What is the different between `Users` and Users MySQL - BittleRyan - 21.08.2014

Quote:

Originally Posted by ******

The official answer is that doing `Users` will work even if the word "Users" one day becomes a MySQL keyword (like "SELECT"), whereas without the quotes won't. For example:

Код:

SELECT * FROM `Insert`

Works.

Код:

SELECT * FROM INSERT

Fails.

Great response. Learn something everyday.

Re: What is the different between `Users` and Users MySQL - SPA - 21.08.2014

Quote:

Originally Posted by BittleRyan

Great response. Learn something everyday.

Agree (Y) .