SQLite version 3.7.16.2 2013-04-12 11:52:43
Enter .help for instructions
Enter SQL statements terminated with a ;
sqlite .tables
CityCountry Languages
Country Country Official Languages
Country CapitalsCountryLanguage
sqlite select count(*)
On Tue, Sep 24, 2013 at 12:35 PM, Staffan Tylen staffan.ty...@gmail.comwrote:
SQLite version 3.7.16.2 2013-04-12 11:52:43
Enter .help for instructions
Enter SQL statements terminated with a ;
sqlite .tables
CityCountry Languages
Country Country
On 24 Sep 2013, at 5:35pm, Staffan Tylen staffan.ty...@gmail.com wrote:
sqlite .tables
CityCountry Languages
Country Country Official Languages
Country CapitalsCountryLanguage
Either don't use spaces in your token names (table names,
On Tue, Sep 24, 2013 at 12:35 PM, Staffan Tylen staffan.ty...@gmail.comwrote:
SQLite version 3.7.16.2 2013-04-12 11:52:43
Enter .help for instructions
Enter SQL statements terminated with a ;
sqlite .tables
CityCountry Languages
Country Country
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
On Tue, Sep 24, 2013 at 12:35 PM, Staffan Tylen staffan.ty...@gmail.comwrote:
SQLite version 3.7.16.2 2013-04-12 11:52:43
Enter .help for instructions
Enter SQL statements terminated with a ;
sqlite .tables
CityCountry Languages
Country Country
On Tue, Sep 24, 2013 at 12:53 PM, Staffan Tylen staffan.ty...@gmail.comwrote:
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 think I see what is happening..
when you
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
Staffan Tylen wrote:
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
CityCountry Languages
Country Country Official Languages
Many who solved this, thank you all.
Staffan
On Tue, Sep 24, 2013 at 7:11 PM, Yuriy Kaminskiy yum...@gmail.com wrote:
Staffan Tylen wrote:
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:
On 9/24/2013 12:49 PM, John Drescher wrote:
On Tue, Sep 24, 2013 at 12:35 PM, Staffan Tylen staffan.ty...@gmail.comwrote:
SQLite version 3.7.16.2 2013-04-12 11:52:43
Enter .help for instructions
Enter SQL statements terminated with a ;
sqlite .tables
CityCountry
: [sqlite] Bug in sqlite3.exe?
On Tue, Sep 24, 2013 at 12:35 PM, Staffan Tylen
staffan.ty...@gmail.comwrote:
SQLite version 3.7.16.2 2013-04-12 11:52:43
Enter .help for instructions
Enter SQL statements terminated with a ;
sqlite .tables
CityCountry Languages
Hello List!
I see unexpected behavior using sqlite3's .read command.
The basic problem is illustrated by the following test file:
C:\type test2.sql
-- two errors, sqlite3 exits
select count(*) from no_table_a;
select count(*) from no_table_b;
C:\
Here's the result of running
13 matches
Mail list logo