You can also access that value within your Perl code, in a DBMS-agnostic
fashion, with the appropriate DBI routine:
http://search.cpan.org/dist/DBI/DBI.pm#last_insert_id
-- Darren Duncan
On 2016-09-11 2:59 PM, mikeegg1 wrote:
I forgot I could use it inside the shell. Thanks.
On Sep 11, 2016, at 16:58, Simon Slavin <slav...@bigfraud.org> wrote:
On 11 Sep 2016, at 10:53pm, mikeegg1 <mikee...@mac.com> wrote:
Thanks. I thought not. I’m doing this from PERL on a Mac and don’t know if I
can fully access last_row_id().
It's not a C function, it's a function you can use inside SQL commands. There
shouldn't be a problem with it.
INSERT INTO myTable VALUES ('Hastings',17);
UPDATE anotherTable SET theRowId = last_row_id() WHERE placeName = 'Hastings';
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users