Skip to content

[Help]SQL Script

Featured Replies

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

 

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

Create an account or sign in to comment

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.