"Igor Tandetnik" <itandetnik-fh9draxc...@public.gmane.org> writes: > Nikolaus Rath <nikolaus-bth8mxji...@public.gmane.org> wrote: >> I understand that running INSERT or DELETE during an active SELECT query >> can get me into trouble. But is it safe to run (in pseudocode): >> >> for value in "SELECT main_column IN mytable": >> >> UPDATE mytable SET other_column='foobar' WHERE main_column=value > > It should be safe. Though I don't see how this would be different than > just updating all rows in a single query: > > UPDATE mytable SET other_column='foobar';
Well, in the actual code 'foobar' is of course a non-trivial function of value. I assume that this does not change the validity of the construction...? Best, -Nikolaus -- »Time flies like an arrow, fruit flies like a Banana.« PGP fingerprint: 5B93 61F8 4EA2 E279 ABF6 02CF A9AD B7F8 AE4E 425C _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
