SQLite: Simple DELETE statement did not work
Posted
by user186446
on Stack Overflow
See other posts from Stack Overflow
or by user186446
Published on 2010-05-07T19:00:08Z
Indexed on
2010/05/07
19:08 UTC
Read the original article
Hit count: 133
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
© Stack Overflow or respective owner
