This question comes up every couple of months or so. It's a
basic misunderstanding of how grouping works.
The answer in your case is
select Visitor_ID, Action, Message, Timestamp
from av2, (select Visitor_ID vid, max(Timestamp) mts
from av2 where Action='I' or Action='O'
Hi,
I'm developing a small reception application for staff to use.
The app records visitors signing in and out of the building.
CREATE TABLE av2 (
Activity_ID INTEGER PRIMARY KEY,
Timestamp TIMESTAMP,
Visitor_ID VARCHAR(8),
Action VARCHAR(1),
Message VARCHAR(255));
insert into av2
No, this won't work (not even with the correction, which is still not correct
code).
To export a database, you need more than just the contents. You need the
structure (schema), indices, constraints, etc. All of this can be created using
the DBD::SQLite driver, but you have to have the
Hi,
this is the exact table definition:
create table wordlinks (
id integer primary key,
document integer,
docword integer,
count integer
)
in fact i wouldn't need the primary key. i need an index on docword
I still think that COPY should be removed from the core, and it can
be emulated by a wrapper or shell. Such a wrapper or shell
functionality can still be bundled with SQLite, but it would be
physically separate and those who don't want it can exclude it easily.
As for VACUUM, that may be a
I agree with your summary as well.
As to any other "utility" functions embedded in the core (Vacuum springs to
mind) I think serious consideration should be given to removing all like
functionality to a separate "support" feature either GUI or command line.
There seems, as always, to be great
Corrected one obvious error...
Puneet Kishor wrote:
On May 24, 2004, at 8:34 AM, H. Wade Minter wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello,
I'm investigating migrating my Perl/Tk application from MySQL to
SQLite. I've got most of the conversion to DBD::SQLite done, but there
are
On 24-mei-04, at 14:04, [EMAIL PROTECTED] wrote:
Version 3.0 of SQLite will support unicode in three different
representations: UTF-8, UTF-16LE, and UTF-16BE. So the question
has come up about what encoding(s) should the COPY command support.
(1) Extend the syntax of the COPY command to
Hi, My 2 cents...
I would prefer to have the COPY as a shell command as a .copy with
options for file-format.
It is not always practical to compile/bind/execute insert statements
especailly while designing your database
and while troubleshooting.
-Original
On May 24, 2004, at 8:34 AM, H. Wade Minter wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello,
I'm investigating migrating my Perl/Tk application from MySQL to
SQLite. I've got most of the conversion to DBD::SQLite done, but there
are a couple of areas I'm stuck on.
My first issue is
Well, generally I think building a business on "free" products, for which
one does not control the source is like building a house on sand. It can be
done, but ... I would have thought your question was related to personal
use. If I can't afford a "commercial" full license product I think I
Hi,
well, i put most things in transactions, but in this case that wouldn't make a
difference.
the query was simply:
create index idx_linktable on linktable (wid)
that ran for hours and hours on the huge table until i killed it, or with benchmarks
as described
in previous post on the tables
...
> now, i tried to put the index on the table afterwards. i tried this when
> the table was real big
> (600Mb, about 40.000.000 rows).. After six hours, sqlite had read and
> wrote 150Gb (!) to disk
> (that is: reading 150Gb, writing 150Gb according to windows taskman) the
> job still wasn't
Hi,
i have the following problem: in my database is one specific table that gets quite a
lot of
inserts..the table consist only of a primary key and three integer values. I need to
index, besides
the primary table, 2 more columns on the table. there is no option to put a 'unique'
index.
if i
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello,
I'm investigating migrating my Perl/Tk application from MySQL to SQLite.
I've got most of the conversion to DBD::SQLite done, but there are a
couple of areas I'm stuck on.
My first issue is that I need to be able to export and import database
Re: The subject of licenses on toolkits:
".Anyway, better solutions [than Microsoft's] have already been
offered so I'll say no more on
this thread."
Am I correct in that the Borland solution offered earlier has a license
restricting it to *personal* use only? If so, then (gulp) is it
Jérôme VERITE wrote:
I remark the vacuum Op do nothing if I turn off the useJournal. Is it normal
?
It is not normal to turn off useJournal. SQLite is untested in that
mode.
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
I remark the vacuum Op do nothing if I turn off the useJournal. Is it normal
?
Thanks in advance.
Jérome
18 matches
Mail list logo