Nikolaus Rath <> 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';

Igor Tandetnik

sqlite-users mailing list

Reply via email to