Habib Posted January 27, 2011 Posted January 27, 2011 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 Quote
0 mogo Posted January 27, 2011 Posted January 27, 2011 Don't delete, just update. UPDATE items SET count = 1000 WHERE item_Id = 5535 AND count > 5000 Quote
Question
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
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.