Re: [sqlite] What about with LAST_INSERT_ROWID() ?

[In the message "[sqlite] What about with LAST_INSERT_ROWID() ?" on Jun 22, 15:09, litenoob writes:] > > Hmm.. don't know sed or awk, but I suppose this weekend would be a good time > to learn! > > Alright, going along with this, is there a better way to get t

[sqlite] What about with LAST_INSERT_ROWID() ?

Hmm.. don't know sed or awk, but I suppose this weekend would be a good time to learn! Alright, going along with this, is there a better way to get the last row id inserted? This is my (completely inefficient) workaround: - - - - - sqlite3 $dbfilename << EOF INSERT INTO tablename (col1,