Debian Codegraph @

www/c3ref/total_changes.html

raw
1 <!DOCTYPE html>
2 <html><head>
3 <meta name="viewport" content="width=device-width, initial-scale=1.0">
4 <meta http-equiv="content-type" content="text/html; charset=UTF-8">
5 <link href="../sqlite.css" rel="stylesheet">
6 <title>Total Number Of Rows Modified</title>
7 <!-- path=../ -->
8 </head>
9 <body>
10 <div class=nosearch>
11 <a href="../index.html">
12 <img class="logo" src="../images/sqlite370_banner.svg" alt="SQLite" border="0">
13 </a>
14 <div><!-- IE hack to prevent disappearing logo --></div>
15 <div class="tagline desktoponly">
16 Small. Fast. Reliable.<br>Choose any three.
17 </div>
18 <div class="menu mainmenu">
19 <ul>
20 <li><a href="../index.html">Home</a>
21 <li class='mobileonly'><a href="javascript:void(0)" onclick='toggle_div("submenu")'>Menu</a>
22 <li class='wideonly'><a href='../about.html'>About</a>
23 <li class='desktoponly'><a href="../docs.html">Documentation</a>
24 <li class='desktoponly'><a href="../download.html">Download</a>
25 <li class='wideonly'><a href='../copyright.html'>License</a>
26 <li class='desktoponly'><a href="../support.html">Support</a>
27 <li class='desktoponly'><a href="../prosupport.html">Purchase</a>
28 <li class='search' id='search_menubutton'>
29 <a href="javascript:void(0)" onclick='toggle_search()'>Search</a>
30 </ul>
31 </div>
32 <div class="menu submenu" id="submenu">
33 <ul>
34 <li><a href='../about.html'>About</a>
35 <li><a href='../docs.html'>Documentation</a>
36 <li><a href='../download.html'>Download</a>
37 <li><a href='../support.html'>Support</a>
38 <li><a href='../prosupport.html'>Purchase</a>
39 </ul>
40 </div>
41 <div class="searchmenu" id="searchmenu">
42 <form method="GET" action="../search">
43 <select name="s" id="searchtype">
44 <option value="d">Search Documentation</option>
45 <option value="c">Search Changelog</option>
46 </select>
47 <input type="text" name="q" id="searchbox" value="">
48 <input type="submit" value="Go">
49 </form>
50 </div>
51 </div>
52 <script>
53 function toggle_div(nm) {
54 var w = document.getElementById(nm);
55 if( w.style.display=="block" ){
56 w.style.display = "none";
57 }else{
58 w.style.display = "block";
59 }
60 }
61 function toggle_search() {
62 var w = document.getElementById("searchmenu");
63 if( w.style.display=="block" ){
64 w.style.display = "none";
65 } else {
66 w.style.display = "block";
67 setTimeout(function(){
68 document.getElementById("searchbox").focus()
69 }, 30);
70 }
71 }
72 function div_off(nm){document.getElementById(nm).style.display="none";}
73 window.onbeforeunload = function(e){div_off("submenu");}
74 /* Disable the Search feature if we are not operating from CGI, since */
75 /* Search is accomplished using CGI and will not work without it. */
76 if( !location.origin || !location.origin.match || !location.origin.match(/http/) ){
77 document.getElementById("search_menubutton").style.display = "none";
78 }
79 /* Used by the Hide/Show button beside syntax diagrams, to toggle the */
80 function hideorshow(btn,obj){
81 var x = document.getElementById(obj);
82 var b = document.getElementById(btn);
83 if( x.style.display!='none' ){
84 x.style.display = 'none';
85 b.innerHTML='show';
86 }else{
87 x.style.display = '';
88 b.innerHTML='hide';
89 }
90 return false;
91 }
92 var antiRobot = 0;
93 function antiRobotGo(){
94 if( antiRobot!=3 ) return;
95 antiRobot = 7;
96 var j = document.getElementById("mtimelink");
97 if(j && j.hasAttribute("data-href")) j.href=j.getAttribute("data-href");
98 }
99 function antiRobotDefense(){
100 document.body.onmousedown=function(){
101 antiRobot |= 2;
102 antiRobotGo();
103 document.body.onmousedown=null;
104 }
105 document.body.onmousemove=function(){
106 antiRobot |= 2;
107 antiRobotGo();
108 document.body.onmousemove=null;
109 }
110 setTimeout(function(){
111 antiRobot |= 1;
112 antiRobotGo();
113 }, 100)
114 antiRobotGo();
115 }
116 antiRobotDefense();
117 </script>
118 <!-- keywords: sqlite3_total_changes sqlite3_total_changes64 -->
119 <div class=nosearch>
120 <a href="../c3ref/intro.html"><h2>SQLite C Interface</h2></a>
121 <h2>Total Number Of Rows Modified</h2>
122 </div>
123 <blockquote><pre>
124 int sqlite3_total_changes(sqlite3*);
125 sqlite3_int64 sqlite3_total_changes64(sqlite3*);
126 </pre></blockquote>
127 <p>
128 These functions return the total number of rows inserted, modified or
129 deleted by all <a href="../lang_insert.html">INSERT</a>, <a href="../lang_update.html">UPDATE</a> or <a href="../lang_delete.html">DELETE</a> statements completed
130 since the database connection was opened, including those executed as
131 part of trigger programs. The two functions are identical except for the
132 type of the return value and that if the number of rows modified by the
133 connection exceeds the maximum value supported by type "int", then
134 the return value of sqlite3_total_changes() is undefined. Executing
135 any other type of SQL statement does not affect the value returned by
136 sqlite3_total_changes().</p>
137
138 <p>Changes made as part of <a href="../foreignkeys.html#fk_actions">foreign key actions</a> are included in the
139 count, but those made as part of REPLACE constraint resolution are
140 not. Changes to a view that are intercepted by INSTEAD OF triggers
141 are not counted.</p>
142
143 <p>The <a href="../c3ref/total_changes.html">sqlite3_total_changes(D)</a> interface only reports the number
144 of rows that changed due to SQL statement run against database
145 connection D. Any changes by other database connections are ignored.
146 To detect changes against a database file from other database
147 connections use the <a href="../pragma.html#pragma_data_version">PRAGMA data_version</a> command or the
148 <a href="../c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntldataversion">SQLITE_FCNTL_DATA_VERSION</a> <a href="../c3ref/file_control.html">file control</a>.</p>
149
150 <p>If a separate thread makes changes on the same database connection
151 while <a href="../c3ref/total_changes.html">sqlite3_total_changes()</a> is running then the value
152 returned is unpredictable and not meaningful.</p>
153
154 <p>See also:
155 <ul>
156 <li> the <a href="../c3ref/changes.html">sqlite3_changes()</a> interface
157 <li> the <a href="../pragma.html#pragma_count_changes">count_changes pragma</a>
158 <li> the <a href="../lang_corefunc.html#changes">changes() SQL function</a>
159 <li> the <a href="../pragma.html#pragma_data_version">data_version pragma</a>
160 <li> the <a href="../c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntldataversion">SQLITE_FCNTL_DATA_VERSION</a> <a href="../c3ref/file_control.html">file control</a>
161 </ul>
162 </p><p>See also lists of
163 <a href="../c3ref/objlist.html">Objects</a>,
164 <a href="../c3ref/constlist.html">Constants</a>, and
165 <a href="../c3ref/funclist.html">Functions</a>.</p>
166