SQLite: Simple DELETE statement did not work
- by user186446
I have a table MRU, that has 3 columns.
(VALUE varchar(255); TYPE varchar(20); DT_ADD datetime)
This is a table simply storing an entry and recording the date time it was recorded. What I wanted to do is: delete the oldest entry whenever I add a new entry that exceeds a certain number.
here is my query:
delete from MRU
where type = 'FILENAME'
ORDER BY DT_ADD limit 1;
The query returns an error.
Thanks
