On Tue, Sep 24, 2013 at 12:35 PM, Staffan Tylen <staffan.ty...@gmail.com>wrote:
> SQLite version 3.7.16.2 2013-04-12 11:52:43 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> .tables > City Country Languages > Country Country Official Languages > Country Capitals CountryLanguage > sqlite> select count(*) from country languages; > The previous is parsed the same as: SELECT count(*) FROM country AS languages; Your are querying the table named "country" and giving it an alias of "languages". > count(*) > ---------- > 239 > sqlite> select count(*) from country official languages; > Error: near "languages": syntax error > sqlite> select count(*) from country official; > count(*) > ---------- > 239 > sqlite> select count(*) from countrylanguage; > count(*) > ---------- > 988 > sqlite> select count(*) from languages; > Error: no such table: languages > sqlite> > > I'm aware the version of SQLite is not current so it might already have > been fixed. > > Staffan > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
