Thank you, Simon! Could you please say me what indexes will be correct?
I'm trying
CREATE INDEX mgwrInd1 ON mgWordsRelations (id_norm)
CREATE INDEX mgwrInd2 ON mgWordsRelations (id_norminrel)
CREATE INDEX wfInd1 ON wform (wordForm)
CREATE INDEX wfInd2 ON wform (wordNorm)
CREATE INDEX wfInd3 ON
Thank you very much! It works well!
Igor Tandetnik wrote:
>
> Try this:
>
> select wf1.wordForm
> from wform wf1 join mgWordsRelations rel on (wf1.wordNorm =
> rel.id_norminrel)
> join wform wf2 on (rel.id_norm = wf2.wordNorm)
> where wf1.ancode = 'someAncode' and wf2.wordForm =
Hello!
Nabble is really wonderful resource, because I received answers to all my
questions. Sorry now, but I have to ask to help me again (if someone could).
I'm not good in sql yet, so if anyone could find a minute to think about
optimization of my sql query I'll be very much obliged.
I have two
I think that my problem is in using LIKE expression for non-ascii strings.
Database encode is UTF-8. When table data in the "base" column (see my first
message for structure) consists of english symbols (ascii) LIKE works
correct, but when I'm trying to execute it on strings consists of UTF8
Jean-Christophe Deschamps wrote:
>
>
> Try ... LIKE !
> select * from lemma where 'Whoever you love' like '%' || base || '%';
> If a row contains base = 'Eve' it should turn up (just an example).
>
> ___
> sqlite-users mailing list
>
Hello! Please, help me if you have a time for this. I have an sqlite database
table:
CREATE TABLE lemma (
id INTEGER PRIMARY KEY,
base TEXT,
preflex_id INTEGER,
type_ancode TEXT,
prefix_id INTEGER
)
In the "base" column I store a string which I need to compare with another
string,
Thanks very much to all for answers! Sorry, I had some troubles with my
internet connection, so I've read them just now.
I need exactly unique value by set of this three columns in my table, that
is correct. Application do not write temporary data to the disc, because it
works in one transaction,
7 matches
Mail list logo