> Le 30 juin 2016 à 14:13, R Smith <rsm...@rsweb.co.za> a écrit : > > There is no way to catch the outcome in the CLI that I know of, but that > doesn't matter. if you are writing scripts for the CLi and not programming > it, you can't possibly have SPEED as a paramount consideration, and if that's > the case, the simple usual upserts in the CLI would work just dandy (and the > order doesn't matter much for lookups, but it is very slightly more efficient > to do the Update first as sometimes there's nothing to update - if the update > is done second, there's always something to update.
Thanks Ryan, Speed concern while using it in scripts is indeed not my concern. I just don't like to have to repeat myself twice... to my computer, especially when I have to tell things first using either the insert or update syntax then say it again using the other syntax. :) And *that* is my concern when having to write a piece of script for some quick data fix. :) -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
