MySQL Syntax
#1

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...
Reply


Messages In This Thread
MySQL Syntax - by MrMou6 - 12.10.2013, 10:50
Re: MySQL Syntax - by MrMou6 - 12.10.2013, 14:17

Forum Jump:


Users browsing this thread: 1 Guest(s)