Re: [sqlite] 1/2 OFF : Leave a few records on a table

"Rubens Jr." <[EMAIL PROTECTED]> writes: > Create Table test (ID integer primary key, log text); > > After inserting some records how can I maintain only > the last 10 records ? > Note that ID may have 'roles', that some records may > be deleted. Something like this should do it: DELETE FROM t

[sqlite] 1/2 OFF : Leave a few records on a table

Hi ! Sorry by Off, but I do not know how to do this with SQlite ! Supose : Create Table test (ID integer primary key, log text); After inserting some records how can I maintain only the last 10 records ? Note that ID may have 'roles', that some records may be deleted. Thanks Rubens Jr. -