[sqlite] Best way to temporarily store data before processing

does this awesome sounding temp table then merge instantly when you commit it even if it?s huge? > On Apr 14, 2015, at 1:01 PM, Scott Hess wrote: > > On Tue, Apr 14, 2015 at 9:37 AM, Jim Callahan > wrote: >> My recollection is that SQLite has a "temp" or "tmp" namespace available >> for interm

Re: [sqlite] another challenging query

you guys are flippin' gods ya know that right? thanks! On Jun 19, 2014, at 10:26 PM, Igor Tandetnik wrote: > On 6/20/2014 1:20 AM, David M. Cotter wrote: >> i want to delete from the table all records with plID = 1, but ONLY those >> that have a corresponding record where plID == 851090 and wh

Re: [sqlite] help writing DELETE with JOIN

okay i figured it out. thank you all so much for your hints and suggestions!! my problem was that my "stal" marked items were the wrong items. once i marked the CORRECT items as stale, the statement worked. also i realized that the old playlist is about to be deleted by the caller of this rou

Re: [sqlite] help writing DELETE with JOIN

outside of the parens? shouldn't it go inside the parens? eg: say the playlist ID i want is "57", would i do this? also: what is the "1" for? sorry for my newb-ness, still learning! but fun! DELETE FROM playlist WHERE EXISTS(SELECT 1 FROM songlist WHERE playlist.playlistID=songlis

Re: [sqlite] help writing DELETE with JOIN

what about "playlistID=X" ? the playlist table has "playlistID", (different playlists) i only want the ones in a particular playlist On Nov 15, 2013, at 5:36 AM, Richard Hipp wrote: > On Fri, Nov 15, 2013 at 2:55 AM, David M. Cotter wrote: > >> i have a "song" table S that has "songID", "play