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
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'
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
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
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
5 matches
Mail list logo