Re: [sqlite] Query on Update or Selective Insert
On 7 August 2013 15:25, Simon Slavinwrote: > > On 7 Aug 2013, at 9:50am, techi eth 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
Re: [sqlite] Query on Update or Selective Insert
On 7 Aug 2013, at 9:50am, techi ethwrote: > 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. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Query on Update or Selective Insert
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
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
Re: [sqlite] Query on Update or Selective Insert
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] 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