[sqlite] autoincrement field
On Thu, 27 Aug 2015 23:40:15 +0200 Jean-Christophe Deschamps wrote: > http://www.sqlite.org/c3ref/last_insert_rowid.html is what you need. Yes, thanks a lot! Lev
[sqlite] autoincrement field
At 23:25 27/08/2015, you wrote: >--- >I have a table structure like this: > >CREATE TABLE padstack ( > id INTEGER PRIMARY KEY AUTOINCREMENT, > pin_number INTEGER, > name TEXT >); > >Is there any way to get the 'id' of newly inserted row? My insert of >course >not contains the 'id' field. >--- http://www.sqlite.org/c3ref/last_insert_rowid.html is what you need.
[sqlite] autoincrement field
I have a table structure like this: CREATE TABLE padstack ( id INTEGER PRIMARY KEY AUTOINCREMENT, pin_number INTEGER, name TEXT ); Is there any way to get the 'id' of newly inserted row? My insert of course not contains the 'id' field. Thanks, Lev
[sqlite] autoincrement field
On 8/27/15, Levente Kovacs wrote: > On Thu, 27 Aug 2015 23:40:15 +0200 > Jean-Christophe Deschamps wrote: > >> http://www.sqlite.org/c3ref/last_insert_rowid.html is what you need. > > Yes, thanks a lot! You should probably also read the documentation on AUTOINCREMENT (https://www.sqlite.org/autoinc.html) since it probably does not do what you think it does. > > Lev > > > > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp drh at sqlite.org
[sqlite] autoincrement field
On 8/27/2015 5:25 PM, Levente Kovacs wrote: > Is there any way to get the 'id' of newly inserted row? http://www.sqlite.org/c3ref/last_insert_rowid.html http://www.sqlite.org/lang_corefunc.html#last_insert_rowid -- Igor Tandetnik