Sent: Friday, December 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
lev
Sent: Thursday, 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
Can you please send the tables structure. This happens when the fields you
are using in the JOIN clause are with different types fro example when
trying to join a VARCHAR with INT
Dobromir Velev
[EMAIL PROTECTED]
- Original Message -
From: "Koen Van Mulders" <[EMAIL PROTECTED]>
To: <[EMA
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 hel