On 09/24/2013 11:53 PM, Staffan Tylen wrote:
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?
It's because the AS keyword is optional. These two are equivalent:
SELECT count(*) FROM Country Languages;
SELECT count(*) FROM Country AS Languages;
Dan.
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
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
