MySQL Syntax - Printable Version

MySQL Syntax - 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 Syntax (/showthread.php?tid=469193)

MySQL Syntax - MrMou6 - 12.10.2013

Code:

UPDATE `cars` SET lock = %i WHERE owner = '%s' AND limit= %i

In MySQL Log:

Code:

[13:54:31] CMySQLHandler::Query(UPDATE `cars` SET 'lock' = 2 WHERE owner = 'Cristiano_Fernandes' AND limit = 1) - An error has occured. (Error ID: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'lock = 2 WHERE owner = 'Cristiano_Fernandes' AND limit = 1' at line 1)

But:

Code:

UPDATE `cars` SET x = %f WHERE owner = '%s' AND limit= %i

Is Good code...

Re: MySQL Syntax - MrMou6 - 12.10.2013

Nobody knows?