How do you enable LIMIT for DELETE in SQLite?

sqlite limit sql-delete
user5243421 picture user5243421 · Dec 1, 2009 · Viewed 17.1k times · Source

Using PHP, I have a simple database that may store multiple items with the same content. I want to delete the first occurrence of an instance when I use DELETE.

How do you enable LIMIT for DELETE in SQLite using PHP?

Answer

Andreas picture Andreas · Jul 20, 2012

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
)

Related questions

Sqlite LIMIT / OFFSET query

I have simple question with Sqlite. What is the difference between this: Select * from Animals LIMIT 100 OFFSET 50 and Select * from Animals LIMIT 100,50

Read More
Get data from database Android

I have a page which can retrieve user data from database but after whole day of trying, I am only able to get the table column name but not the value inside. this is my code to create database public …

Read More
Select first row in each GROUP BY group?

As the title suggests, I'd like to select the first row of each set of rows grouped with a GROUP BY. Specifically, if I've got a purchases table that looks like this: SELECT * FROM purchases; My Output: id | customer | total …

Read More