Trigger after select -

i have sqlite3-database. there's table logs. these logs readed tool , writed text-file (or else) it.

after this, logs can deleted. possible create trigger in sqlite3 after select, automaticly deletes logs?

like this:

create trigger after_select_x after select on x begin   delete x id = selected.id; end; 

but doesn't work.

thanks

best regards

there no such thing "trigger after select". check out trigger syntax reference.

i suggest use wrapper function perform every select statement in application, , handle logs in function.