Normally I think you'd just loop through each on their own, since they don't have any dependencies on each other.
select 1 from foo where id = ?;--process if no records returned But you could also do with inputValues (inputValue) as (values (?), (?), (?)) select inputValue from inputValues where not exists (select 1 from foo where id = inputValue); But there you have to change the query itself depending on how many input values you have, etc. -----Original Message----- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Mark Wagner Sent: Tuesday, December 12, 2017 2:26 PM To: SQLite mailing list Subject: Re: [sqlite] values ? My use case was this. For some given input, find which of those input values do not have corresponding rows in a given table. In other words something like this (but values seemed easier). select '1' as x union select '2' as x union select '3 as x where x not in (select id from foo); Picture the 1,2,3 as some form of input which requires further processing if we don't have rows for them. Perhaps there's a better way to do this that I'm not thinking of. On Tue, Dec 12, 2017 at 11:07 AM, Stephen Chrzanowski <pontia...@gmail.com> wrote: > Nifty... but... With no option for "where" or "order by", where would this > come in useful? > > On Tue, Dec 12, 2017 at 1:48 PM, Mark Wagner <m...@google.com> wrote: > > > Argh. Yes, I was on 3.8.2. Thanks! > > > > On Tue, Dec 12, 2017 at 10:45 AM, Richard Hipp <d...@sqlite.org> wrote: > > > > > On 12/12/17, Mark Wagner <m...@google.com> wrote: > > > > My reading of https://sqlite.org/syntax/select-core.html makes me > > think > > > > that I should be able to issue something like values('foo'); and get > a > > > row > > > > with a single column whose value is 'foo'. But I get a syntax error. > > > > > > > > Probably obvious to the right people but what am I missing? > > > > > > It probably means you are using an older version of SQLite. The > > > syntax you describe as introduced in version 3.8.3 (2014-02-03). > > > -- > > > D. Richard Hipp > > > d...@sqlite.org > > > > > _______________________________________________ > > 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 > _______________________________________________ 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
