Sqlite how delete last added entry of a table

sqlite sql-delete
Markus picture Markus · Nov 3, 2010 · Viewed 9.3k times · Source

I'm trying to delete the last added entry of a table:

DELETE FROM notes ORDER BY created_at DESC LIMIT 1

This just causes the following error:

near "ORDER": syntax error

Why might I be getting this error? (notes exists and has records in it!)

Answer

srinathhs picture srinathhs · Nov 3, 2010

Try this

DELETE FROM notes WHERE id = (SELECT MAX(id) FROM notes);

Related questions

How to Delete All Items From SQLite in Android

I would like to make an app where the user clicks a button, and the SQLite database is cleared. Here's what I've tried so far: db.delete(TABLE_NAME, null, null); What am I doing wrong?

Read More
Remove all table rows from SQLite database table

I want to remove all rows that i entered from my SQLite database table. The table name is tbltask. I tried to drop the table and delete * from table, but those are giving me runtime errors. I want to trigger …

Read More
Delete SQLite Row with where clause with multiple clauses

I've been searching around and not managed to find a solution or working example so here goes. I've set up an SQLite database which has five columns with different fields which effectively builds a list for the user. There will …

Read More