[Help]SQL Script

[Habib]

i try to make sql script to delete items from items.sql if count>5000 and to set it to 1000 but all time i get error

any one can help me ?

 

my code is :

 

DELETE FROM items WHERE item_Id=5535 IF count>5000 SET count =1000

 

[mogo]

Don't delete, just update. UPDATE items SET count = 1000 WHERE item_Id = 5535 AND count > 5000