On Thu, Dec 17, 2009 at 12:05 PM, Martin Kirsche <[email protected]> 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
