1
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
3
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
4
<title>Last Insert Rowid</title>
5
<style type="text/css">
8
font-family: Verdana, sans-serif;
13
a:visited { color: #734559 }
15
.logo { position:absolute; margin:3px; }
31
.toolbar a { color: white; text-decoration: none; padding: 6px 12px; }
32
.toolbar a:visited { color: white; }
33
.toolbar a:hover { color: #044a64; background: white; }
35
.content { margin: 5%; }
36
.content dt { font-weight:bold; }
37
.content dd { margin-bottom: 25px; margin-left:20%; }
38
.content ul { padding:0px; padding-left: 15px; margin:0px; }
41
.se { background: url(../images/se.gif) 100% 100% no-repeat #044a64}
42
.sw { background: url(../images/sw.gif) 0% 100% no-repeat }
43
.ne { background: url(../images/ne.gif) 100% 0% no-repeat }
44
.nw { background: url(../images/nw.gif) 0% 0% no-repeat }
46
/* Things for "fancyformat" documents start here. */
47
.fancy img+p {font-style:italic}
48
.fancy .codeblock i { color: darkblue; }
49
.fancy h1,.fancy h2,.fancy h3,.fancy h4 {font-weight:normal;color:#044a64}
50
.fancy h2 { margin-left: 10px }
51
.fancy h3 { margin-left: 20px }
52
.fancy h4 { margin-left: 30px }
53
.fancy th {white-space:nowrap;text-align:left;border-bottom:solid 1px #444}
54
.fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top}
55
.fancy #toc a { color: darkblue ; text-decoration: none }
56
.fancy .todo { color: #AA3333 ; font-style : italic }
57
.fancy .todo:before { content: 'TODO:' }
58
.fancy p.todo { border: solid #AA3333 1px; padding: 1ex }
59
.fancy img { display:block; }
60
.fancy :link:hover, .fancy :visited:hover { background: wheat }
61
.fancy p,.fancy ul,.fancy ol { margin: 1em 5ex }
62
.fancy li p { margin: 1em 0 }
63
/* End of "fancyformat" specific rules. */
69
<div><!-- container div to satisfy validator -->
71
<a href="../index.html">
72
<img class="logo" src="../images/sqlite370_banner.gif" alt="SQLite Logo"
74
<div><!-- IE hack to prevent disappearing logo--></div>
75
<div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
77
<table width=100% style="clear:both"><tr><td>
78
<div class="se"><div class="sw"><div class="ne"><div class="nw">
79
<table width=100% style="padding:0;margin:0;cell-spacing:0"><tr>
82
<a href="../about.html">About</a>
83
<a href="../sitemap.html">Sitemap</a>
84
<a href="../docs.html">Documentation</a>
85
<a href="../download.html">Download</a>
86
<a href="../copyright.html">License</a>
87
<a href="../news.html">News</a>
88
<a href="../support.html">Support</a>
91
gMsg = "Search SQLite Docs..."
92
function entersearch() {
93
var q = document.getElementById("q");
94
if( q.value == gMsg ) { q.value = "" }
95
q.style.color = "black"
96
q.style.fontStyle = "normal"
98
function leavesearch() {
99
var q = document.getElementById("q");
100
if( q.value == "" ) {
102
q.style.color = "#044a64"
103
q.style.fontStyle = "italic"
108
<div style="padding:0 1em 0px 0;white-space:nowrap">
109
<form name=f method="GET" action="http://www.sqlite.org/search">
110
<input id=q name=q type=text
111
onfocus="entersearch()" onblur="leavesearch()" style="width:24ex;padding:1px 1ex; border:solid white 1px; font-size:0.9em ; font-style:italic;color:#044a64;" value="Search SQLite Docs...">
112
<input type=submit value="Go" style="border:solid white 1px;background-color:#044a64;color:white;font-size:0.9em;padding:0 1ex">
116
</div></div></div></div>
118
<div class=startsearch></div>
120
<a href="intro.html"><h2>SQLite C Interface</h2></a><h2>Last Insert Rowid</h2><blockquote><pre>sqlite3_int64 sqlite3_last_insert_rowid(sqlite3*);
121
</pre></blockquote><p>
122
Each entry in an SQLite table has a unique 64-bit signed
123
integer key called the <a href="../lang_createtable.html#rowid">"rowid"</a>. The rowid is always available
124
as an undeclared column named ROWID, OID, or _ROWID_ as long as those
125
names are not also used by explicitly declared columns. If
126
the table has a column of type <a href="../lang_createtable.html#rowid">INTEGER PRIMARY KEY</a> then that column
127
is another alias for the rowid.</p>
129
<p>This routine returns the <a href="../lang_createtable.html#rowid">rowid</a> of the most recent
130
successful <a href="../lang_insert.html">INSERT</a> into the database from the <a href="../c3ref/sqlite3.html">database connection</a>
131
in the first argument. As of SQLite version 3.7.7, this routines
132
records the last insert rowid of both ordinary tables and <a href="../vtab.html">virtual tables</a>.
133
If no successful <a href="../lang_insert.html">INSERT</a>s
134
have ever occurred on that database connection, zero is returned.</p>
136
<p>If an <a href="../lang_insert.html">INSERT</a> occurs within a trigger or within a <a href="../vtab.html">virtual table</a>
137
method, then this routine will return the <a href="../lang_createtable.html#rowid">rowid</a> of the inserted
138
row as long as the trigger or virtual table method is running.
139
But once the trigger or virtual table method ends, the value returned
140
by this routine reverts to what it was before the trigger or virtual
141
table method began.</p>
143
<p>An <a href="../lang_insert.html">INSERT</a> that fails due to a constraint violation is not a
144
successful <a href="../lang_insert.html">INSERT</a> and does not change the value returned by this
145
routine. Thus INSERT OR FAIL, INSERT OR IGNORE, INSERT OR ROLLBACK,
146
and INSERT OR ABORT make no changes to the return value of this
147
routine when their insertion fails. When INSERT OR REPLACE
148
encounters a constraint violation, it does not fail. The
149
INSERT continues to completion after deleting rows that caused
150
the constraint problem so INSERT OR REPLACE will always change
151
the return value of this interface.</p>
153
<p>For the purposes of this routine, an <a href="../lang_insert.html">INSERT</a> is considered to
154
be successful even if it is subsequently rolled back.</p>
156
<p>This function is accessible to SQL statements via the
157
<a href="../lang_corefunc.html#last_insert_rowid">last_insert_rowid() SQL function</a>.</p>
159
<p>If a separate thread performs a new <a href="../lang_insert.html">INSERT</a> on the same
160
database connection while the <a href="../c3ref/last_insert_rowid.html">sqlite3_last_insert_rowid()</a>
161
function is running and thus changes the last insert <a href="../lang_createtable.html#rowid">rowid</a>,
162
then the value returned by <a href="../c3ref/last_insert_rowid.html">sqlite3_last_insert_rowid()</a> is
163
unpredictable and might not equal either the old or the new
164
last insert <a href="../lang_createtable.html#rowid">rowid</a>.
165
</p><p>See also lists of
166
<a href="objlist.html">Objects</a>,
167
<a href="constlist.html">Constants</a>, and
168
<a href="funclist.html">Functions</a>.</p>