The standard behavior is to back out any changes made by the current statement, which means that none of the changes to any of the rows are preserved in case of a constraint violation.
SQLite offers an ON CONFLICT clause which allows the programmer to choose from a set of defined behaviours. See http://www.sqlite.org/lang_conflict.html But regardless of the choice, each row of a table is either modified in all specified columns or in none at all. Note that without a WHERE clause the UPDATE statement will modify all rows of the table. -----Ursprüngliche Nachricht----- Von: techi eth [mailto:techi...@gmail.com] Gesendet: Mittwoch, 07. August 2013 12:06 An: General Discussion of SQLite Database Betreff: Re: [sqlite] Query on Update or Selective Insert Apologies to use programming convention!!! Here I mean to have Colum UPDATE table_name SET column1 = value1, column2 = value2...., columnN = valueN Here N is 100. Cheers - Techi On Wed, Aug 7, 2013 at 3:26 PM, Hick Gunter <h...@scigames.at> wrote: > What do you mean by "variable"? > > -----Ursprüngliche Nachricht----- > Von: techi eth [mailto:techi...@gmail.com] > Gesendet: Mittwoch, 07. August 2013 10:50 > An: General Discussion of SQLite Database > Betreff: [sqlite] Query on Update or Selective Insert > > Query on Update or Selective Insert: > > 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. > > Cheers - > > Techi > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > ---------------------------------------------------------------------- > ---- > Gunter Hick > Software Engineer > Scientific Games International GmbH > Klitschgasse 2 - 4, A - 1130 Vienna, Austria FN 157284 a, HG Wien > Tel: +43 1 80100 0 > E-Mail: h...@scigames.at > > This e-mail is confidential and may well also be legally privileged. > If you have received it in error, you are on notice as to its status > and accordingly please notify us immediately by reply e-mail and then > delete this message from your system. Please do not copy it or use it > for any purposes, or disclose its contents to any person as to do so > could be a breach of confidence. Thank you for your cooperation. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -------------------------------------------------------------------------- Gunter Hick Software Engineer Scientific Games International GmbH Klitschgasse 2 – 4, A - 1130 Vienna, Austria FN 157284 a, HG Wien Tel: +43 1 80100 0 E-Mail: h...@scigames.at This e-mail is confidential and may well also be legally privileged. If you have received it in error, you are on notice as to its status and accordingly please notify us immediately by reply e-mail and then delete this message from your system. Please do not copy it or use it for any purposes, or disclose its contents to any person as to do so could be a breach of confidence. Thank you for your cooperation. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
