On 9/24/2013 12:49 PM, John Drescher wrote:
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
Although I am a bit surprised that this query succeeded since there is no
languages table.
"languages" is an alias here. The query is equivalent to
select count(*) from country AS languages;
AS is optional and can be omitted.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users