Help Update table

[zujarka99]

Hello MXC Nation, I'm here to ask some wise man an advice, why when i try to update WHOLE table it isn't working I'm updateing it with a navicat comannd
UPDATE etcitems SET price = 1

And it still not working, any solutions for this ?

Edited September 29, 2017 by zujarka99
grammar misspelling

[eressea]

What does "not working" mean? Does it give you error, does it timeout or what? If there's no error at all, try

UPDATE etcitems SET price=1;
SELECT COUNT(*) FROM etcitems WHERE price<>1;

If it returns 0, then it works - maybe you just work in a transaction and need to

COMMIT;

?

[zujarka99]

8 minutes ago, eressea said:

What does "not working" mean? Does it give you error, does it timeout or what? If there's no error at all, try

UPDATE etcitems SET price=1;
SELECT COUNT(*) FROM etcitems WHERE price<>1;

If it returns 0, then it works - maybe you just work in a transaction and need to

COMMIT;

?

Solved 3 minutes ago with:
UPDATE etcitem SET price = 0 where price > 1;