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