Re: [sqlite] Order Statistic Trees

On Sat, May 17, 2014 at 9:41 PM, Scott Robison wrote: > On May 17, 2014 8:40 PM, "Simon Slavin" wrote: > > Just want to check: this is what it sounds like, right ? Your user has > a window open where they are scrolling through the table, ordered by

[sqlite] Small bug with .import shell command

Hello, When the first value of the first line is empty, .import fails: $ echo '|test' > ko.csv $ echo '""|test' > ok.csv $ sqlite3 SQLite version 3.8.4.3 2014-04-03 16:53:12 sqlite> .import ko.csv test ko.csv: empty file sqlite> .import ok.csv test sqlite> An error happens also when the table

Re: [sqlite] Simple Select from IN - from a newbie.

I'm making good headway with the conversion from the use of strings into a normalized database. With the kind help of everyone on the list, I can retrieve the data from the new structure. I am now at the stage of saving the data to the new structure. Each time I do an update, I need to update

Re: [sqlite] Simple Select from IN - from a newbie.

On Sat, 24 May 2014 03:08:32 -0700 (PDT), Humblebee wrote: >I'm making good headway with the conversion from the use of strings >into a normalized database. With the kind help of everyone on the >list, I can retrieve the data from the new structure. > >I am now at the

Re: [sqlite] Simple Select from IN - from a newbie.

On 24 May 2014, at 11:08am, Humblebee wrote: > I looked up the SQLite > documentation and found that Insert works on multiple rows. Can I > update multiple rows with one statement ? No. But if you do not already understand BEGIN and END you should read about them.

Re: [sqlite] Simple Select from IN - from a newbie.

On 2014/05/24 12:08, Humblebee wrote: I'm making good headway with the conversion from the use of strings into a normalized database. With the kind help of everyone on the list, I can retrieve the data from the new structure. I am now at the stage of saving the data to the new structure.

Re: [sqlite] Simple Select from IN - from a newbie.

Thank you everyone for your help and especially for the very detailed and clear explanation. There are so many intricacies of SQL that it's hard to know what to do as a beginner. Having such clear and understandable explanations makes learning the ropes so much easier. I am supplementing my