SQLite Forum

(Deleted)
Login
we have the following sqlite command that works:

**UPDATE feeder SET quantity = quantity + 1 WHERE quantity < 200 AND available = 1 RETURNING id, food_weigth, quantity**

but we would like to add a limit 1 since we don't want to update all the feeders

something like (it doesn't work):

**UPDATE feeder SET quantity = quantity + 1 WHERE quantity < 200 AND available = 1 LIMIT 1 RETURNING id, food_weigth, quantity**

nyl