How do you enable LIMIT for DELETE in SQLite?
Solution 1:
You can use limit with select and you can combine select and delete like:
DELETE FROM Foo
WHERE someColumn in
(
SELECT someColumn FROM FOO WHERE SomeCondition LIMIT 200
)
Solution 2:
DELETE FROM table WHERE rowid = (SELECT rowid FROM table WHERE condition LIMIT 1 )