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?
I agree, the names should be quoted ... On Tue, Sep 24, 2013 at 6:50 PM, Simon Slavin <[email protected]> wrote: > > On 24 Sep 2013, at 5:35pm, Staffan Tylen <[email protected]> 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. > > Simon. > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
