On 7 August 2013 15:25, Simon Slavin <[email protected]> wrote: > > On 7 Aug 2013, at 9:50am, techi eth <[email protected]> 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
