Cool. Thank you so much.
Shawn M. Downey
MPR Associates
632 Plank Road, Suite 110
Clifton Park, NY 12065
518-371-3983 x3 (work)
860-508-5015 (cell)
-Original Message-
From: Lawrence Chitty [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 30, 2004 3:55 PM
To: [EMAIL PROTECTED]
- Original Message -
From: "Downey, Shawn" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, September 30, 2004 7:26 PM
Subject: [sqlite] complex query question
> The query should return exactly 3 records:
>
> Hoyhoy | 2 | 1 | 1
> Fred | 0 | 2 | 0
> Tony | 1 | 1 | 0
Thursday, September 30, 2004, 10:34:50 AM, DRH wrote:
> The problem reported by ticket #924 appears to be mingw brain damage,
> not a bug in SQLite. Can somebody who uses a recent version of
> mingw (I'm still using a version from 3 or 4 years ago - a version
> that works) please suggest a
Hello all,
First let me say thank you very much for a very useful mailing list.
I have a somewhat complex SQL query question. Given the table:
CREATE TABLE times(name CHAR(32) not null,
time1 CHAR(10),
time2 CHAR(10),
Hi
Is there a way of either...
(a) getting a list of databases attached (using attached command), or
(b) Finding the database name used for any given table name name)
For instance: If I have a statement "select * from fred", is there a way
I can find out what database "fred" is on, or at least
Thursday, September 30, 2004, 10:34:50 AM, DRH wrote:
> The problem reported by ticket #924 appears to be mingw brain damage,
> not a bug in SQLite. Can somebody who uses a recent version of
> mingw (I'm still using a version from 3 or 4 years ago - a version
> that works) please suggest a
> Brass Tilde wrote:
> > sqlite> select last_insert_rowid() from Author;
> > 5
> > 5
> > 5
> > 5
> > 5
> >
>
> There are five rows in the table Author. One row
> of the result set is generated for each row in the
> table. Thus you have 5 rows of output. This is
> as designed.
I wondered about
[EMAIL PROTECTED] wrote:
Third issue is the collation. MySQL exports 'collate latin1_german1_ci'
what SQLite tries to handle but cannot since it only supports BINARY,
REVERSE and NOCASE collation.
You can create the latin1_german1_ci collation using the
sqlite3_create_collation() API.
I have 4
Brass Tilde wrote:
sqlite> select last_insert_rowid() from Author;
5
5
5
5
5
There are five rows in the table Author. One row
of the result set is generated for each row in the
table. Thus you have 5 rows of output. This is
as designed.
You probably meant to say:
select last_insert_rowid()
The problem reported by ticket #924 appears to be mingw brain damage,
not a bug in SQLite. Can somebody who uses a recent version of
mingw (I'm still using a version from 3 or 4 years ago - a version
that works) please suggest a reasonable workaround.
Hi,
I'm just trying to port some MySQL-4.1.5-gamma DB to SQLite3.
I exported the MySQL-DB-Metadata using PHPMyAdmin and SQLite did not
accept it for several reasons.
One reason is MyAdmin exports colum-names in "strange" quotes. There's
IMHO no urgent need for SQLite to process these.
Next issue
Running Win2K, with all current patches, I use the SQLite3.exe program to
create a database named "test.db" using the .read command. The file
"test.sql" contains the following table definition:
create table Author
(
AuthorKey integer primary key not null,
LastName
On Tue, 28 Sep 2004, Vladimir Vukicevic wrote:
>On Tue, 28 Sep 2004 12:09:45 +0100 (BST), Christian Smith
><[EMAIL PROTECTED]> wrote:
>> Why?
>>
>> Functions are static, you set them up at initialisation time. So why
>> register functions after preparing a statement for execution.
>
>A single
13 matches
Mail list logo