[EMAIL PROTECTED] wrote:
Hello all,
First of all, allow me to wish everyone a Happy New Year and I hope it'll be a
good one for all.
My question is (and I've raised this topic back in September, but didn't get
back to it since), does anyone have a free/commercial add-on for SQLite v3 to
perform
Greg Miller wrote:
You used a backslash, escaping the 'c' character. Notice that the
error message refers to "c:cygwin" rather than "c:\cygwin", which
isn't equivalent.
Try "ls c:/cygwin" instead.
I thought I had before posting... but you're right, this works!
-Alan
--
Alan Mead - [EMAIL PROTECT
Markus Hoenicka wrote:
Well, that doesn't work, but the following does:
sqlite c:/cygwin/usr/local/share/refdb/db/refdb
i.e. absolute paths require a DOS-style drive letter.
Are you doing this at the Cygwin prompt or Window's command prompt? My
installation of Cygwin doesn't recognize DOS styl
Christopher Petrilli wrote:
Has anyone had any experience in storing a million or more rows in a
SQLite3 database? I've got a database that I've been building, which
gets 250 inserts/second, roughly, and which has about 3M rows in it.
At that point, the CPU load is huge.
Note that I've got synci
Markus Hoenicka wrote:
Hi,
I've just built 2.8.15 on Cygwin which worked without a hitch (thanks to those
who added Cygwin support in the past). However, I came across a problem that
makes working with databases a bit inconvenient. It seems like the library does
not understand absolute paths, only
I have quite a lot of data. Naturally, as an SQLite 3.08 database, my
data are significantly bigger than when they were a flat text file.
As an aside, I'm very impressed with SQLite. Basic SELECTS in this 1.4
million record database are more or less instantaneous. The performance
doing more
D. Richard Hipp wrote:
[EMAIL PROTECTED] wrote:
The formatting seems all messed up after the 3rd example
in the "ATTACH command" section. (As viewed from Mozilla.)
I didn't notice any obvious formatting issues viewing it using Netscape
7.2 or Firefox Preview 1.0 (on Windows XP).
I plan on printi
Maybe I'm blind but I've looked and don't see the answer to this... what
is the format for the file to be imported using .import in the sqlite3
CLI database management tool?
-Alan
Brass Tilde wrote:
select ID,
(select SERVER_ID from A where A.ID=B.GROUP_ID) as GROUP_ID
from B [...]
It mentions, among others:
Variable subqueries
Subqueries must be static. They are evaluated only once. They
may not, therefore, refer to variables in the main qu
Gerhard Haering wrote:
On Thu, Nov 11, 2004 at 09:40:44AM -0500, [EMAIL PROTECTED] wrote:
[...] The following SQL does not work, complaint is "Error: no such column:
B.GROUP_ID"
select ID,
(select SERVER_ID from A where A.ID=B.GROUP_ID) as GROUP_ID
from B [...]
Looks like you haven't r
10 matches
Mail list logo