How do you enable LIMIT for DELETE in SQLite?

Asked 2009-12-01T07:10:45.363

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?

sqlite limit sql-delete

Edit Report

1 Answer

DELETE FROM table WHERE rowid = (SELECT rowid FROM table WHERE condition LIMIT 1 )

answered 2012-10-01T13:12:37.037

How do you enable LIMIT for DELETE in SQLite?

1 Answer

Your Answer