I think u've got to type the query after typing(next to) ANALYZE.
-Original Message-
From: Joe Wilson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 12, 2006 8:58 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] SQL error: near "ANALYZE": syntax error
SQLite 3.2.2 does not support
SQLite 3.2.2 does not support ANALYZE.
I think it first appears in SQLite 3.2.3.
--- Steve Bergman <[EMAIL PROTECTED]> wrote:
> I feel kind of silly asking this. I must be doing something really silly.
>
> I go into the command line client with:
>
> $ sqlite3 filename.db
>
> at the sqlite>
I feel kind of silly asking this. I must be doing something really silly.
I go into the command line client with:
$ sqlite3 filename.db
at the sqlite> prompt, I type:
ANALYZE;
and I get:
SQL error: near "ANALYZE": syntax error
I am running sqlite 3.2.2.
What am I doing wrong?
Thanks,
Nuno Lucas wrote:
..., but it should work the same.
Famous last words. :-)
On 4/11/06, Siobhan Kivler <[EMAIL PROTECTED]> wrote:
> Thank you very much for replying. I was using the
> 3.2.2 version of the sqlite WinCE port. I tried using
> the pre-compiled win32 version 3.3.5 as you suggested,
> but I got a couple of errors. GetLastError returned
> ERROR_MOD_NOT_FOUND,
wow, I really have to learn much more about the SQL, thanks for your great
help!
-Original Message-
From: Dennis Cote [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 11, 2006 7:13 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] How to handle large amount of data?
André Goliath
André Goliath wrote:
Unless you have ebtter suggestions my DB will look like this.
('Takes' are the objects)
CREATE TABLE [takefields]
(
[take] integer NOT NULL ,
[field] integer NOT NULL ,
[content] memo,
PRIMARY KEY ([field])
);
Primary keys must be unique. You will have
> -Original Message-
> From: Siobhan Kivler [mailto:[EMAIL PROTECTED]
>
> Thank you very much for replying. I was using the
> 3.2.2 version of the sqlite WinCE port. I tried using the
> pre-compiled win32 version 3.3.5 as you suggested, but I got
> a couple of errors. GetLastError
On 4/11/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> [EMAIL PROTECTED] wrote:
> > Hi, i have several databases with same structure on several hosts, and
> > want them to generate globaly unique ids.
>
> Then random() function generates 64-bits of high-quality
> randomness that you can use
[EMAIL PROTECTED] wrote:
> Hi, i have several databases with same structure on several hosts, and
> want them to generate globaly unique ids.
Then random() function generates 64-bits of high-quality
randomness that you can use for a ID. Such IDs will be
unique with a very high probability,
Hi, i have several databases with same structure on several hosts, and
want them to generate globaly unique ids.
So can I add row to table with explicit id and without modyfing rowid sequence?
eg
insert into db (value) values ( 'first' ) ;
insert into db (value) values ( 'second' ) ;
insert
Thank you very much for replying. I was using the
3.2.2 version of the sqlite WinCE port. I tried using
the pre-compiled win32 version 3.3.5 as you suggested,
but I got a couple of errors. GetLastError returned
ERROR_MOD_NOT_FOUND, and the compiler said that the
target platform of the DLL did not
I think that´s exactly what I´m going to do.
I´ll have to get the ok from my customer regarding the longer time of an
INSERT/UPDTAE,
but I think he will be ok with that.
Unless you have ebtter suggestions my DB will look like this.
('Takes' are the objects)
CREATE TABLE [takefields]
(
13 matches
Mail list logo