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 <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. > > Simon. > _______________________________________________ > 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
