Sqlite doesn't have variable. While last row id is available other ways, a trick to emulate a variable is to create a temp table with one field. You put the value in to the that field. You can then cross join with the rest of your table as need be, or do a sub-select to value a SET command.
David From: mikeegg1 <mikee...@mac.com> To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Sent: Sunday, September 11, 2016 5:48 PM Subject: [sqlite] Does sqlite3 have variables like Oracle? 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? 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. I don’t have an example at the moment of what I’m trying to do. I’m generating a bunch of statements into a file that I will then ‘sqlite3 data.sqlite3 < data.sql’. I’m using the value of -14 (just a number) as a place holder in a bunch of insert statements then at the end of each group I do an update to the actual rowid. Mike _______________________________________________ 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