If your default is '0', I think, the new query should work.
Thanks
Javier
- Original Message -
From: Donna Robinson <[EMAIL PROTECTED]>
To: Javier <[EMAIL PROTECTED]>
Sent: Monday, April 29, 2002 7:14 PM
Subject: Re: Cross querying databases (again)
> Hi,
Hi.
Run EXPLAIN for both queries and see if it explains the difference (my
first guess is be that the indexes support the one query, but not the
other).
Also, what does "never finishes" mean? Please list the processlist
(using SHOW or mysqladmin) and have a look at the state of the query.
Bye,
I'm not entirely sure if MySQL supports these (I assume so, but not
positive). Try these two queries instead:
To find similar:
(SELECT * FROM ddetails)
INTERSECT CORRESPONDING BY name
(SELECT * FROM ddata)
Find differences:
(SELECT * FROM ddetails)
EXCEPT CORRESPONDING BY name
(SELECT * FROM
Hi,
I am going nuts!
I am querying two databases which are very similar to find the differences
between various tables.
These two tables are 15 rows and 14 rows respectively.
Why does this work (finds all similar rows):
select ddetails.name, ddata.name
from dancedetails.coupletypes as ddetails,
