Sqlite how delete last added entry of a table

Question

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!)

is created_at a column you define? – NG. Nov 03 '10 at 13:13 — NG., Nov 03 '10 at 13:13

score 26 · Accepted Answer · edited Jan 30 '14 at 02:26

26

Try this

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

edited Jan 30 '14 at 02:26

hichris123

10,145
15
56
70

answered Nov 03 '10 at 13:16

srinathhs

1,998
4
19
33

What if I don't have an `id` column? – Rolf Mar 01 '18 at 09:47
1

There is always a id .. it is called rowid or ROWID and is automatically assigned, – JackNorthrup Jun 15 '18 at 09:29

score 2 · Answer 2 · answered Nov 03 '10 at 13:15

2

delete from notes where created_at = ( select max(created_at) from notes );

Watch out, this will not limit the number of rows deleted. If there are more than one row at max(created_at), this will delete all of them because the subject you specified does not exist (last added entry of a table).

answered Nov 03 '10 at 13:15

0xCAFEBABE

5,576
5
34
59

Thats the solution for me! Thanks for your hint! I just use the max(id) to make sure, that there is really just the last entered id... – Markus Nov 03 '10 at 13:25

Sqlite how delete last added entry of a table

2 Answers2