Ronan Lucio wrote:
The problem is that if I use OR in the where clause, MySQL won't
use the indexes in the row_id column.
Yes, it will, as long as the OR conditions are on the *same* column.
WHERE row_id IN (2,5,7)
and
WHERE (row_id = 2 OR row_id = 5 OR row_id = 7)
are equivalent. I prefer IN
At 8:18 -0600 11/11/04, Jay Blanchard wrote:
[snip]
When I run the follow query:
DELETE
FROM table
WHERE client_id = 1
AND row_id IN (2,5,7)
only the first record is deleted.
Am I doing something wrong or is it a MySQL bug?
[/snip]
It is not a bug, just say it out loud
"AND row_id is 2 OR 5 OR
Michael,
> What are you talikng about? Queries don't halt on the first row matched.
> For example:
It´s my thought, too. But it isn´t happen in my MySQL Server.
Now, doing the same tests you did I got the same results of you.
Well, I´ll inspect my code again looking for some error that I
didn´t
Jay,
> It is not a bug, just say it out loud
> "AND row_id is 2 OR 5 OR 7"
>
> Once the OR condition is satisfied once, the query will halt.
The problem is that if I use OR in the where clause, MySQL wont
use the indexes in the row_id column.
One important thing that I forgot to say is I ru
Jay Blanchard wrote:
[snip]
When I run the follow query:
DELETE
FROM table
WHERE client_id = 1
AND row_id IN (2,5,7)
only the first record is deleted.
Am I doing something wrong or is it a MySQL bug?
[/snip]
It is not a bug, just say it out loud
"AND row_id is 2 OR 5 OR 7"
Once the OR conditio
[snip]
When I run the follow query:
DELETE
FROM table
WHERE client_id = 1
AND row_id IN (2,5,7)
only the first record is deleted.
Am I doing something wrong or is it a MySQL bug?
[/snip]
It is not a bug, just say it out loud
"AND row_id is 2 OR 5 OR 7"
Once the OR condition is satisfied onc
