[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

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

Re: [sqlite] SQlite on flash filesystem

y > were created during that session. It's rare to see this actually > happen (few systems create a cache that reflects the whole drive then > never bother to flush it) but the specs of the hardware involved do > allow it. -- Levente Kovacs CTO, CSO http://levente.logonex.eu

Re: [sqlite] archive of database

Simon, Tony, Thank you very mucj r your answer! It was helpful. All the best! 73 de HA5OGL -- Levente Kovacs CTO, CSO http://levente.logonex.eu ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo

[sqlite] archive of database

? Will it be able to read older version of database? What is the most portable way? Thanks, Levente -- Levente Kovacs CTO, CSO http://levente.logonex.eu ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite