SQLite Database
> Subject: Re: [sqlite] Bug in sqlite3.exe?
>
> 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 S
On 9/24/2013 12:49 PM, John Drescher wrote:
On Tue, Sep 24, 2013 at 12:35 PM, Staffan Tylen 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
CityCountry
Many who solved this, thank you all.
Staffan
On Tue, Sep 24, 2013 at 7:11 PM, Yuriy Kaminskiy wrote:
> Staffan Tylen wrote:
> > On Tue, Sep 24, 2013 at 6:50 PM, Simon Slavin
> wrote:
> >
> >> On 24 Sep 2013, at 5:35pm, Staffan Tylen
Staffan Tylen wrote:
> On Tue, Sep 24, 2013 at 6:50 PM, Simon Slavin wrote:
>
>> On 24 Sep 2013, at 5:35pm, Staffan Tylen wrote:
>>
>>> sqlite> .tables
>>> CityCountry Languages
>>> Country Country
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
On Tue, Sep 24, 2013 at 12: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?
>
>
I think I see what is happening..
when
On Tue, Sep 24, 2013 at 12:35 PM, Staffan Tylen 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
> CityCountry Languages
> 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 wrote:
>
> On 24
On Tue, Sep 24, 2013 at 12:35 PM, Staffan Tylen 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
> CityCountry Languages
> Country
On 24 Sep 2013, at 5:35pm, Staffan Tylen wrote:
> sqlite> .tables
> CityCountry Languages
> Country Country Official Languages
> Country CapitalsCountryLanguage
Either don't use spaces in your token names (table
On Tue, Sep 24, 2013 at 12:35 PM, Staffan Tylen 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
> CityCountry Languages
> Country
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
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