Many who solved this, thank you all. Staffan
On Tue, Sep 24, 2013 at 7:11 PM, Yuriy Kaminskiy <yum...@gmail.com> wrote: > Staffan Tylen wrote: > > On Tue, Sep 24, 2013 at 6:50 PM, Simon Slavin <slav...@bigfraud.org> > wrote: > > > >> On 24 Sep 2013, at 5:35pm, Staffan Tylen <staffan.ty...@gmail.com> > wrote: > >> > >>> sqlite> .tables > >>> City Country Languages > >>> Country Country Official Languages > >>> Country Capitals CountryLanguage > >> Either don't use spaces in your token names (table names, column names, > >> index names, etc.) or quote them when you use them. Something like > >> > >> select count(*) from "country official languages"; > >> > >> or > >> > >> select count(*) from [country official languages]; > >> > >> will probably work. I avoid all space in token names because they cause > >> problems with other versions of SQL too, and I don't want to get into > >> dangerous habits. > > > Well, it's not my database I'm looking at. What puzzles me is that > Country > > Languages works but Country Official Languages doesn't, so could there > be a > > parsing problem? > > No. `Languages` is interpreted as *alias* to table `Country`: > > SELECT ... FROM Country Languages > is same as > SELECT ... FROM [Country] AS [Languages] > > And > SELECT ... FROM Country Official > is same as > SELECT ... FROM [Country] AS [Official] > > And that's why `SELECT ... FROM Country Languages` return exactly same > result as > `SELECT FROM Country Official`; if you would've issued just `SELECT ... > FROM > Country`, it would've returned same result as well. > > > I agree, the names should be quoted ... > > > -- > A: Because it messes up the order in which people normally read text. > Q: Why is top-posting such a bad thing? > A: Top-posting. > Q: What is the most annoying thing on usenet and in e-mail? > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
