MySQL Fehler

10/07/2013 16:49 Chip'#1
Hay zusammen ich habe folgendes Problem wenn ich eine query ausführe via quest kommt folgender Fehler:

Rootname:/.../... # ERROR 1064 (42000) at line 1: 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 '=UPDATE account set cash = cash+'10' WHERE id = '1'' at line 1

Woran kann es liegen?
Kann mir jemand vllt via TeamViewer zeigen woran es liegt. Will ja aus den Fehler lernen :P
10/07/2013 17:04 .Shōgun#2
remove the ' ' from the numbers, like this:

UPDATE ACCOUNT set cash = cash + 10 where id = 1

' ' define a string and you can't do arithmetic operations with strings
10/07/2013 17:29 Chip'#3
Thanks, but the quest is 100% right.
We have maybe a problem with the MySQL-Interface