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; > 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. > > This does not look like a bug to me. You need to escape spaces. John _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users