hello, I'm trying to run the following query:
UPDATE "users" SET "coins" = '0' WHERE "bought" = '0'
but I get this error:
#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 '"users" SET "coins" = '0' WHERE "bought" = '0'' at line 1
I need your help to run this query.
45 freelancers are bidding on average $2/hour for this job
Hey its a quick job, less than 5 mins. Let me know if you are interested. You can pay only after the solution works. Hope we communicate soon. Regards, Tushar
Hi, If "bought" is INT in database then you should not use ' to number, modify it as "bought" = 0 and try, remove quotes for ZERO. send me the full query code so I can understand it better.
hello this simple job to run the query you can try with the given below query hope this will run perfectly 'UPDATE `users` SET "coins" = '0' WHERE "bought" = '0''