On 17/08/2009 2:37 PM, Dan Kennedy wrote:
On Aug 17, 2009, at 11:05 AM, John Machin wrote:
On 17/08/2009 11:41 AM, Shane Harrelson wrote:
INDEXED BY doesn't allow you to specify which index to use. It
just causes
the query to fail if SQLite thinks it should use an index different
then
The INDEXED BY feature was introduced to address concerns that SQLite
might
suddenly start using a different plan for a query in the field than
it
did
in the office during testing. Either because somebody ran ANALYZE, or
because
the SQLite version was upgraded. In this situation, some
Hello
I have a table that has a lot of duplicates in the Name column. I'd
like to only keep one row for each.
The following lists the duplicates, but I don't know how to delete the
duplicates and just keep one:
SELECT name FROM members GROUP BY name HAVING COUNT(*) 1;
Thank you.
Dear all,
I would like to discuss a new feature in the SQLite R-tree which is not very
difficult to implement but would improve
query performance a lot for use cases where the MBR (minimum bounding
rectangle) of the query object leads to
a too large candidate set.
First of all the data
Hello to all SQLite people
(that's my first post - please be patient:-))
I already searched the mailings from 2008/2009 but could not find a post
that describes this problem.
I have a select over a few tables, and since many tables use identical names
for some columns (like Id), I rename the
Hello,
Before I go ahead and write a script to loop through all the rows, I
was wondering if SQLite supports functions to convert DD MM into
the MySQL-friendly -MM-DD, and whether those functions are
localized so that it understands month names in languages other than
English?
Here's an
Hi,
If you are looking for a delete - command, then you have to decide which
of the duplicate rows you want to keep. Are they all the same even in
the other fields?
Perhaps you want to do something like
delete from members where exists (select rowid from members m2 where
m2.name = members
Mohammad Reaz Uddin wrote:
I downloaded 'sqlite-amalgamation-3.6.16.tar.gz' and used makefile to
compile it.
sqlite is a shell script, wrapper to a compiled binary in .libs directory.
--
Zaga
You have worked and not worked. Not working is the hardest work of all.
Gilles Ganault wrote:
Before I go ahead and write a script to loop through all the rows, I
was wondering if SQLite supports functions to convert DD MM into
the MySQL-friendly -MM-DD, and whether those functions are
localized so that it understands month names in languages other than
Dinu Scheppelmann (DAISY) wrote:
Unfortunately when I get the column names by function
sqlite3_column_origin_name(), the result columns have the names
DokId, Name and Name again - instead of Id, PatientName and
Name!!
You want sqlite3_column_name
Igor Tandetnik
On Mon, Aug 17, 2009 at 3:15 AM, Dan Kennedy danielk1...@gmail.com wrote:
The INDEXED BY feature was introduced to address concerns that SQLite
might
suddenly start using a different plan for a query in the field than
it
did
in the office during testing. Either because somebody ran
Matt Sergeant wrote:
On Fri, 14 Aug 2009 12:33:30 -0400, Angus March wrote:
I want my INSERT done right away, I just don't want it to be flushed
from the filesystem's write-behind cache until the kernel decides, not
when SQLite decides.
Did you mean you do want it to be flushed
On Mon, 17 Aug 2009 10:47:23 -0400, Angus March wrote:
Because yes, that's what synchronous=OFF means. It stops SQLite from
issuing fflush calls (effectively).
Right, and this is implied by the documentation, but I was concerned
that the documentation might be playing fast and loose,
Matt Sergeant wrote:
On Mon, 17 Aug 2009 10:47:23 -0400, Angus March wrote:
Because yes, that's what synchronous=OFF means. It stops SQLite from
issuing fflush calls (effectively).
Right, and this is implied by the documentation, but I was concerned
that the documentation
--- On Sat, 8/15/09, Dan Kennedy danielk1...@gmail.com wrote:
From: Dan Kennedy danielk1...@gmail.com
Subject: Re: [sqlite] 3.6.17 test failure
To: General Discussion of SQLite Database sqlite-users@sqlite.org
Date: Saturday, August 15, 2009, 12:36 AM
On Aug 15, 2009, at 2:14 AM, Ken
On 17 Aug 2009, at 12:46am, Miroslav Zagorac wrote:
Mohammad Reaz Uddin wrote:
I downloaded 'sqlite-amalgamation-3.6.16.tar.gz' and used makefile to
compile it.
sqlite is a shell script, wrapper to a compiled binary in .libs
directory
wrapped in a mystery, inside an enigma.
Simon.
On 17 Aug 2009, at 3:47pm, Angus March wrote:
I was concerned
that the documentation might be playing fast and loose, saying that
fflush (or fsync, or fdatasync) won't be called, when it really means
that it won't be called during any call to step() or finalize(), while
it would be called
On Mon, Aug 17, 2009 at 11:53 AM, D. Richard Hipp d...@hwaci.com wrote:
On Aug 17, 2009, at 11:41 AM, Matt Sergeant wrote:
Kernels will fflush when a file handle is closed
Not according to Ted Ts'o (creator of the Ext2/3/4 filesystems). See,
for example, the extensive discussions of
Shane Harrelson wrote:
To the original question though, with PRAGMA synchronous=OFF, SQLite will
NOT do explicit fsync()'s. A exception to this occurs with attached DB's
and a transaction; when the transaction is committed and the master journal
is deleted, SQLite fsyncs the directory that
David Bicking-2 wrote:
As written, you were selecting any record with the correct date
regardless of Ensemble or Steuck.
David
The following seem to work:
SELECT * FROM tblZO_Haupt AS hpt
WHERE
hpt.zo_tblEnsemble =
AND hpt.zo_tblStueck = ...
AND hpt.datum = (
SELECT
On Mon, 17 Aug 2009 13:05:53 +0200, Martin Engelschalk
engelsch...@codeswift.com wrote:
If you are looking for a delete - command, then you have to decide which
of the duplicate rows you want to keep. Are they all the same even in
the other fields?
Perhaps you want to do something like
delete
On Mon, 17 Aug 2009 07:44:15 -0400, Igor Tandetnik
itandet...@mvps.org wrote:
update membres set dateinscription=
substr(dateinscription, -4) || '-' ||
(case substr(dateinscription, 4, length(dateinscription) - 8)
when 'January' then '01' when 'February' then '02' ...
when
I have a broken database file, with a journal. It is opened read-only
(via sqlite3_open_v2()). The statement PRAGMA user version is
prepared successfully. When sqlite3_step() is called, the return code
is SQLITE_IOERR. The extended code is SQLITE_IOERR_TRUNCATE. What
exactly does this mean?
JAB
On Mon, 2009-08-17 at 15:05 -0700, Leo Freitag wrote:
David Bicking-2 wrote:
As written, you were selecting any record with the correct date
regardless of Ensemble or Steuck.
David
The following seem to work:
SELECT * FROM tblZO_Haupt AS hpt
WHERE
hpt.zo_tblEnsemble =
AND
Thanks everybody.
On Mon, Aug 17, 2009 at 5:22 AM, Simon Slavin
slav...@hearsay.demon.co.ukwrote:
On 17 Aug 2009, at 12:46am, Miroslav Zagorac wrote:
Mohammad Reaz Uddin wrote:
I downloaded 'sqlite-amalgamation-3.6.16.tar.gz' and used makefile to
compile it.
sqlite is a shell
25 matches
Mail list logo