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(). :)
Mike > On Sep 11, 2016, at 16:52, Simon Slavin <slav...@bigfraud.org> wrote: > > > On 11 Sep 2016, at 10:48pm, mikeegg1 <mikee...@mac.com> wrote: > >> I think Oracle (a long distant memory) has variables like @variable or >> @@variable where you can do something like '@variable = select rowid from >> table where field = 4' and then later do 'insert into othertable (field2) >> value(@variable)’. Does this make sense? > > Yes. I understand how variables could be useful. But SQLite doesn't have > variables the user can assign. > >> I’m wanting to in the shell select lastrowid then update a bunch of inserted >> rows in a different table with the previously inserted lastrowid. > > See the function "last_insert_rowid()" on the page > > <https://www.sqlite.org/lang_corefunc.html> > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
