On Thu, Dec 17, 2009 at 12:05 PM, Martin Kirsche <martin.kirs...@gmx.net> wrote: > is it possible in SQLite to find out which row had been modified by an > UPDATE statement?
Not automatically. You would have to track it yourself with some code like this: sqlite> create temporary table update_list as select rowid as "id" from foo where bar=2 ; sqlite> select * from foo where rowid in (select id from update_list) ; sqlite> update foo set bar=1 where bar=2 ; sqlite> select * from foo where rowid in (select id from update_list) ; Regards, - Robert _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
