trying to learn sql queries, help please

[drunk3nrabbit]

i'm trying to make all stackable items stack to 999, and leave weapons and the like alone.

UPDATE `items` If `maxcount`>'1' then SET `maxcount`='999';

that is the query that i tried, it dosen't work, but it makes sense to me. could someone give me a pointer as to why the syntax is wrong?

thanks

 

[drunk3nrabbit]

help?

 

[zebra]

UPDATE `items` If `maxcount`='1' then SET `maxcount`='999';

Try that

 

[drunk3nrabbit]

thanks, but i don't want to set anything that has a value of "nothing", 0, or 1 to 999, just anything that has a value greater than 1

 

[zebra]

im not sure but If would be replaced by where i believe.

try if this works
UPDATE `items` where `maxcount`= greater than '1' then SET `maxcount`='999';

c what happens.

 

[drunk3nrabbit]

nope, that still gives a syntax error

 

[zebra]

Also try ALTER instead of the UPDATE.

 

[jab416171]

ALTER is for adding and deleting entire rows.
Try
SELECT maxcount FROM items WHERE maxcount > 1
That'll give you the cells that you need
Maybe you can select them all and put 999

 

[drunk3nrabbit]

figured it out from the MYSQL forums

UPDATE `items`
SET `maxcount`='999'
where `maxcount`>'1';