> For example, if a table has multiple columns with UNIQUE indexes.
But in my case, the table doesn't have any UNIQUE indexes, so it seems that the
REPLACE statement can't affect more than one row. This is something that
sqlite3GenerateConstraintChecks could check.
> The fact that the situation
On Thu, 18 Feb 2010, P Kishor wrote:
> SELECT l.llid, l.name, SUM(s.endKM - s.beginKM) AS distance
> FROM lotic AS l JOIN streamlength AS s ON l.llid = s.llid
> WHERE l.llid = '1226038453652'
> GROUP BY l.llid, l.name
Thank you. Now I know.
Much appreciated,
Rich
On Thu, Feb 18, 2010 at 1:06 AM, Rich Shepard wrote:
> I'd appreciate learning how to correctly write a SELECT statement that
> reports the SUM of one returned column.
>
> I can select all relevant rows, but don't know where to put the
> SUM(distance) phrase:
>
> SELECT l.llid, l.name, s.end
I'd appreciate learning how to correctly write a SELECT statement that
reports the SUM of one returned column.
I can select all relevant rows, but don't know where to put the
SUM(distance) phrase:
SELECT l.llid, l.name, s.endKM - s.beginKM AS distance
FROM lotic AS l, streamlengt
Alexey,
that gives me a Tcl VFS inside an SQLite database. I'm looking for the reverse:
I'd like to access an SQLite database within a Tclkit--i.e., within a Tcl VFS.
Is that possible? It seems that SQLite itself cannot "find" the database, even
though a normal file command can see it, give
Hello!
On Wednesday 17 February 2010 05:57:51 Matthew Smith wrote:
> SQLiteVFS a C-language routine for access any file system, on which the
> SQLite database is found. Doesn't appear to give me access to the Tcl VFS.
No, you may search vfs::sqlite3 package for Tcl.
Best regards, Alexey Pechniko
For some reasons it is more convenient for the project to
have a few smaller databases with unrelated data than one containing
everything. My only concern is RAM memory.
How much burden/memory overhead an additional database would introduce?
Thank you for your input,
Samuel
__
You might also see how well INTERSECT performs on your Latitude/Longitude
query. Put an index on (float) LAT and another on (float) LON and use an
INTEGER primary key in MYTABLE.
select * from MYTABLE
JOIN
(
select id from MYTABLE
where
(lat >= 30 and lat <= 33)
INTERSECT
select id from MYTABL
On 17 Feb 2010, at 3:44pm, D. Richard Hipp wrote:
> On Feb 17, 2010, at 6:52 AM, Hick Gunter wrote:
>
>> Ok I went back to square one and retrieved the amalgamation source
>> from the recommended distribution. It is still failing at the
>> "reduce" step before the "shift 627", which is where
Hello!
See:
sqlite> select snippet(file_text) as offsets from file_text where
file_text.rowid=7836 and file_text match 'mobigroup';
...://offline.mts.mobigroup.ru/ )
2. Выбрать...
sqlite> select offsets(file_text) as offsets from file_text where
file_text.rowid=7836 and file_text match 'mobigro
On Feb 17, 2010, at 6:52 AM, Hick Gunter wrote:
> Ok I went back to square one and retrieved the amalgamation source
> from the recommended distribution. It is still failing at the
> "reduce" step before the "shift 627", which is where the
> sqlite3Attach() function is called.
>
>
> [sgi...
On Wed, Feb 17, 2010 at 12:35:11AM -0800, Jeremy Spiegel scratched on the wall:
> In reading http://www.sqlite.org/tempfiles.html, it sounds like a
> statement journal file should only be created for statements that
> might change multiple rows and which might abort. It should be
> possible for s
The following seems to cause a statement journal to be used on every "replace
into" statement:
> create table T (col1 integer primary key not null, col2 integer not null );
> begin transaction;
> replace into T (col1, col2) values (1,2);
> replace into T (col1, col2) values (3,4);
> ...
> commit
13 matches
Mail list logo