19, 2003 13:52
Subject: Re: Problem with EQ_REF and ALL
Hello,
first of all, tnx for the great help so far !
I run MySQL 3.24.
You say I have some duplicate indexes
I didn't add KEY(klant_id) for instance, phpmyadmin did that :-s
How do i drop the KEY but keep the PRIMARY KEY
, December 18, 2003 17:52
Subject: Re: Problem with EQ_REF and ALL
Please excuse me if this comes to your personal mailbox,
i have no clue on how to use these lists :-)
I am proud I could post my problem, I don't know how to reply to it :-(.
Anyway, here are the table structures
Someone please help me...
I have 2 queries (in the end I end up joining them with a LEFT JOIN, but they don't
work properly)
SELECT *
FROM tbl_v_batch b
LEFT JOIN tbl_v_levering l ON l.ver_lev_id = b.batch_lever_id
LEFT JOIN tbl_klanten k ON k.klant_id = l.ver_lev_klant_id
This one gives ALL
Hi,
Have you indexed the fields you're using in the JOIN clauses?
Dobromir Velev
[EMAIL PROTECTED]
- Original Message -
From: Koen Van Mulders [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, December 18, 2003 15:45
Subject: Problem with EQ_REF and ALL
Someone please help me
I think they are all indexed, yes.
I have an index on :
bb.ver_id
b.batch_bestel_id
k.klant_id (k1 is the same)
b.batch_lever_id
l.ver_lev_id
Tnx in advance
- Original Message -
From: Dobromir Velev
To: Koen Van Mulders ; [EMAIL PROTECTED]
Sent: Thursday, December 18, 2003 3:14 PM
Subject: Re: Problem with EQ_REF and ALL
Hi,
Have you indexed the fields you're using in the JOIN clauses?
Dobromir Velev
[EMAIL PROTECTED]
- Original
To: Koen Van Mulders ; [EMAIL PROTECTED]
Sent: Thursday, December 18, 2003 3:14 PM
Subject: Re: Problem with EQ_REF and ALL
Hi,
Have you indexed the fields you're using in the JOIN clauses?
Dobromir Velev
[EMAIL PROTECTED]
- Original Message -
From: Koen Van Mulders [EMAIL PROTECTED
PROTECTED]
Sent: Thursday, December 18, 2003 16:54
Subject: Problem with EQ_REF and ALL
I think they are all indexed, yes.
I have an index on :
bb.ver_id
b.batch_bestel_id
k.klant_id (k1 is the same)
b.batch_lever_id
l.ver_lev_id
Tnx in advance
--
MySQL General Mailing List
For list archives