On 7 August 2013 15:25, Simon Slavin <slav...@bigfraud.org> wrote: > > On 7 Aug 2013, at 9:50am, techi eth <techi...@gmail.com> wrote: > >> I am trying to update 100 variables at a time & due to some of the reason 99 >> th or any mid index variable cause update to fail. >> >> In that case this query has to execute it again for the entire variable or >> only for failed variable. > > If the whole of the UPDATE cannot be completed, none of the UPDATE is done. > > Simon.
If a conflict arises, none of the row is updated. But see http://www.sqlite.org/lang_conflict.html. An update with ignore conflict resolution can update rows even if some rows cause conflict; those rows that cause conflict will be skipped. Regards, Simon _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
