On 4/7/07, John Stanton <[EMAIL PROTECTED]> wrote:
DISAM, a CISAM clone might suit your needs.
Thanks John. I'll look into that. :)
try this:
delete from mytable
where id not in ( select id from mytable order by id desc limit n )
On 4/7/07, Eric S. Johansson <[EMAIL PROTECTED]> wrote:
what is the easiest way to hold on to the last N records and delete all
older? I can't figure out the right where expression.
--
--
what is the easiest way to hold on to the last N records and delete all
older? I can't figure out the right where expression.
--- eric
--
Speech-recognition in use. It makes mistakes, I correct some.
-
To
Good morning all,
Sorry to spam the sqlite list but I thought this might be the best place to
ask.
I'm trying to find an (embedded) database package to fill a specific need
and wondered if anyone can provide a recommendation?
Requirements:
* disk based storage
* As freaking FAST as possible!
Ok, then I'm out. I don't have an answer for the last one either - however
you could do this on a view, which joins both tables.
Mike
-Ursprüngliche Nachricht-
Von: Paul Quinn [mailto:[EMAIL PROTECTED]
Gesendet: Samstag, 7. April 2007 17:54
An: sqlite-users@sqlite.org
Betreff: Re:
I did set up a trigger for DELETEs, but even then the fts_table would find a
way to have more rows than master after a short while. Some delete's are
simply being ignored/failed by the FTS module it seems.
I would have liked to also use triggers for INSERTs, but how do you create a
trigger
How about managing fts_table using triggers attached to the master table?
That should take care of synchronization issues IMHO.
Mike
-Ursprüngliche Nachricht-
Von: Paul Quinn [mailto:[EMAIL PROTECTED]
Gesendet: Samstag, 7. April 2007 09:08
An: sqlite-users@sqlite.org
Betreff: [sqlite]
7 matches
Mail list logo