Lukket

SQL query to update table value

hello, I'm trying to run the following query:

UPDATE "users" SET "coins" = '0' WHERE "bought" = '0'

but I get this error:

MySQL said:

Documentation

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

Færdigheder: Grafisk Design, HTML, PHP, Web Design

Se mere: value in graphic design, need sql help, where to get graphic design help, SQL Query, query table, get sql help, php sql syntax error, 1064 php, error query 1064, mysql help table, sql syntax error, php mysql 1064, php sql update, update server error, mysql sql syntax, query query, sql syntax, mysql update table, error 1064, sql query help, mysql error 1064, table error, afonsobusiness, Query design, sql error 1064 mysql

Om arbejdsgiveren:
( 152 bedømmelser ) Manchester, United Kingdom

Projekt-ID: #6236679

45 freelancere byder i gennemsnit $2/time for dette job

waelfree

Hi, I can do that ...............................................................................................

$2 USD / time
(105 bedømmelser)
7.0
w3bexpert

Dear Sir/Madam, Thank you for viewing our PM. As noted in our bid, we are keenly interested in helping you complete the work you need to be done. We assure you that our team of professionals will complete your proje Mere

$2 USD / time
(97 bedømmelser)
6.4
cristisst

for table names, field names you don't have to use double-quote nor simple quote but this ` or you can leave them clear. just for field values those must be between simple quote or double: ' or ". the right query sh Mere

$2 USD / time
(113 bedømmelser)
6.2
csajit

Hey, How are you doing??? Please check the solution below. UPDATE `users` SET `coins` = 0 WHERE `bought` = 0 Thanks, Ajit

$2 USD / time
(178 bedømmelser)
6.2
virtual7

Hello there It should be something like this :) UPDATE users SET coins = '0' WHERE bought = '0' Good luck.

$2 USD / time
(68 bedømmelser)
6.0
sat12

Hi, I am joomla, virtuemart expert having 5 years of experience... recently i completed these projects [url removed, login to view] [url removed, login to view] [url removed, login to view] http://www.vitaltickets.c Mere

$6 USD / time
(123 bedømmelser)
5.8
sprextech

----------------------------------------------------------Please Consider on My BID--------------------------------------------------- Hi, I am ready to start right now. I have great experience in PHP , OpenCart , Mag Mere

$5 USD / time
(66 bedømmelser)
5.5
unieyes48

hi, it is one minute [url removed, login to view] allow me to finish it now. or open chat window to discuss it further THanks

$2 USD / time
(38 bedømmelser)
5.1
semicolonweb

Can show it to you directly without any extra details ..just hire me and you will be done in minutes.. thanks waiting here to do it fast..

$2 USD / time
(19 bedømmelser)
4.6
elboukharimu

Aucune proposition n'a encore été fournie.

$11 USD / time
(8 bedømmelser)
4.3
sarpinfotech

just try this UPDATE `users` SET `coins` = '0' WHERE `bought` = '0' this must will work thank you

$2 USD / time
(11 bedømmelser)
4.2
DrMDodd

Nominate me now and I will do this for you now. I have over 8 years experience programming in SQL and .NET

$2 USD / time
(3 bedømmelser)
4.1
karand

Hi there, I have read you project description and understand perfectly what need's to be done. Message me.

$2 USD / time
(23 bedømmelser)
4.0
tusharpt

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

$2 USD / time
(7 bedømmelser)
3.9
san99kar

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.

$2 USD / time
(14 bedømmelser)
3.7
L0veToWork

Hi, Let me have a try. its a small issue .thanks!.................................... ....................... please check my feedback., correct query is: UPDATE users SET coins = '0' WHERE bought = '0' Mere

$2 USD / time
(7 bedømmelser)
3.6
codesetter01

Hi Hire me I will solve your problem right now or ping me I will provide solution for it. I hope you will ping me right now.

$2 USD / time
(11 bedømmelser)
3.5
adyuthindia

Hi, I know the issue please ping me. I have vast experience in SQL queries and debugging. I have the fix for your problem

$2 USD / time
(4 bedømmelser)
3.4
phpexpert1981

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''

$2 USD / time
(7 bedømmelser)
3.3
igorssv

Hello try this query: UPDATE "users" SET "coins" = '0' WHERE "bought" = '0' Hope this solves your problem.

$2 USD / time
(3 bedømmelser)
3.3