[sqlite] autoincrement field

2015-08-28 Thread Levente Kovacs 
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

2015-08-28 Thread Jean-Christophe Deschamps 
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

2015-08-28 Thread Levente Kovacs 
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

2015-08-27 Thread Richard Hipp 
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

2015-08-27 Thread Igor Tandetnik 
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