[sqlite] autoincrement field

[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.