"Trevor Talbot" <[EMAIL PROTECTED]> writes:
> On 11/4/07, Ken <[EMAIL PROTECTED]> wrote:
>
> He's referring to section 6 of http://www.sqlite.org/datatype3.html
> which says otherwise.
Yes, section 6: mentioning "strict affinity" mode and "no affinity"
mode. Unfortunately there was no tag, so I
I All:
Suppose a table:
CREATE TABLE 'myTable' (
A INTEGER NOT NULL,
B INTEGER NOT NULL,
C INTEGER);
Do is there some query to return if there are some duplicate files and/or
who are they?
Consider duplicate file if there are two or more rows with the same values.
I.E:
two or more with sa
A.J.Millan <[EMAIL PROTECTED]> wrote:
Suppose a table:
CREATE TABLE 'myTable' (
A INTEGER NOT NULL,
B INTEGER NOT NULL,
C INTEGER);
Do is there some query to return if there are some duplicate files
and/or
who are they?
Consider duplicate file if there are two or more rows with the same
valu
After further research, I realize that suggestion 2 below is not
necessary.
I had not realized that SQLite core supports default value declarations
in call
to sqlite3_declare_vtab(). So by defining any default values when
defining
virtual table columns, one knows in xUpdate callback for INSERT tha
Igor Tandetnik wrote:
A.J.Millan <[EMAIL PROTECTED]> wrote:
Suppose a table:
CREATE TABLE 'myTable' (
A INTEGER NOT NULL,
B INTEGER NOT NULL,
C INTEGER);
Do is there some query to return if there are some duplicate files
and/or who are they?
Consider duplicate file if there are two or more ro
Igor:
The proposed solution seem list all rows in the table. Perhaps miss some
thing in between myTable t1 and myTable t2?
Gerry:
Yours solution does not list any at all. It is likely that there are not
duplicated entrys (at least must not happen that.).
Thanks for yours input.
A.J.Mill
A.J.Millan <[EMAIL PROTECTED]> wrote:
The proposed solution seem list all rows in the table. Perhaps miss
some
thing in between myTable t1 and myTable t2?
Right. Add another condition:
and t1.rowid != t2.rowid
Igor Tandetnik
-
Per your wiki link:
Q) How can the strict affinity mode be used which is claimed to exist on
http://www.sqlite.org/datatype3.html A) This has not been implemented as of
version 3.3.13.
Jarl Friis <[EMAIL PROTECTED]> wrote: "Trevor Talbot" writes:
> On 11/4/07, Ken wrote:
>
> He's referri
On 05/11/2007, A.J.Millan <[EMAIL PROTECTED]> wrote:
> I All:
>
> Suppose a table:
>
> CREATE TABLE 'myTable' (
> A INTEGER NOT NULL,
> B INTEGER NOT NULL,
> C INTEGER);
>
> Do is there some query to return if there are some duplicate files and/or
> who are they?
>
> Consider duplicate file if ther
Hi All,
I'm new in your mailing list.
I need to use sqlite and not sqlite3 because of php still support only the
first version.
I read that sqlite3 support table renaming with common sql syntax
alter table table1 rename to table2
but, although it works fine on sqlite3, it doesn't work on sqlite
Simon Davies
wrote:
I use:
select rowid, A, B, C
from t
where A||B||C in
( select A||B||C
from t
group by A, B, C
having count(*)>1
);
Wouldn't that mistakenly consider a record ('xy', 'z', 'w') to be
duplicate of ('x', 'yz', 'w') ?
Igor Tandetnik
--
On 05/11/2007, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
> Simon Davies
> wrote:
> > I use:
> >
> > select rowid, A, B, C
> > from t
> > where A||B||C in
> > ( select A||B||C
> > from t
> > group by A, B, C
> > having count(*)>1
> > );
>
> Wouldn't that mistakenly consider a record ('xy', 'z', 'w'
If I have data as follows, they wont show up when I try to search for
them.=20 [[[ ]]]=20
[EMAIL PROTECTED]&*=20
()_+|{}:=14<>?=20
-=3D\[];',./=20
@@@ %%%=20
### ^^^=20
___---=20
Ho_mer=20
[EMAIL PROTECTED]&*()_+|`{}:=14<>?-=3D\[];=12,./=20
_Storage-Room=20
@ # $=20
_ - +=20
% ^ &=20
I'm new to this forum and something of a novice in SQL, but I'm not sure
that any of the queries presented have met the criteria requested, or at
least not in the simplest manner possible. Consider the following
table:
CREATE TABLE t1(f1, f2, f3);
INSERT INTO "t1" VALUES('x','y','z');
INSERT INTO
Igor Tandetnik
> select rowid, A, B, C
> from t
> where A||B||C in
> ( select A||B||C
> from t
> group by A, B, C
> having count(*)>1
> );
Wouldn't that mistakenly consider a record ('xy', 'z', 'w') to be
duplicate of ('x', 'yz', 'w') ?
Igor Tandetnik
Due the fact that, in this case, the co
Ken <[EMAIL PROTECTED]> writes:
> 1. (*) text/plain
>
> Per your wiki link:
>
> Q) How can the strict affinity mode be used which is claimed to exist on
> http://www.sqlite.org/datatype3.html A) This has not been implemented as of
> version 3.3.13.
Yes I read that (I referenced it)
Hi Valerio,
On Mon, 5 Nov 2007 18:51:20 +0100, "Valerio Bontempi"
<[EMAIL PROTECTED]> wrote:
>Hi All,
>
>I'm new in your mailing list.
>I need to use sqlite and not sqlite3 because of php still support only the
>first version.
>I read that sqlite3 support table renaming with common sql syntax
>a
Hi all,
In a virtual table context, I expected a statement such as
select * from t where x like 'abc%'
to pass a constraint for the LIKE clause to xBestIndex method of virtual
table module but it doesn't get such a constraint. I expected
SQLITE_INDEX_CONSTRAINT_MATCH. Do I have to do somethin
To answer my own question:
The magic is in either
SQLITE_CASE_SENSITIVE_LIKE
compile time option or
CASE_SENSITIVE_LIKE pragma.
I have seen this before, but it just didn't stick in my small memory
bank.
Mark
> -Original Message-
> From: Evans, Mark (Tandem)
> Sent: Monday, Novembe
Hi sqlite-users!
In other terms, which built-in functions can I safely remove (or rename)
without getting internal errors?
I hope I can remove or rename all of them without compilation or execution
errors... What do you think?
Thanks a lot!
Here's the list! ;-)
min FUNCTION
max FUNCTION
typeof
--- Aladdin Lampé <[EMAIL PROTECTED]> wrote:
> In other terms, which built-in functions can I safely remove (or rename)
> without getting
> internal errors?
> I hope I can remove or rename all of them without compilation or execution
> errors... What do you
> think?
It depends on your use.
Some
Hi there,
As title, just curious whether have plan for later version, for example
3.4.x?
Thanks,
Halton.
-
To unsubscribe, send email to [EMAIL PROTECTED]
22 matches
Mail list logo
