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,
Hi,
Hope you don't mind me hassling you about this yet again.
>> ... So you would need to run two queries, a LEFT JOIN and a
>> RIGHT JOIN (or a LEFT JOIN with tables swapped) to get all
>> results.
> ... ... which is what I did in the end.
except that on further checking it doesn't work!
T
Hello
On Thu, Apr 25, 2002 at 03:29:34AM +0100, [EMAIL PROTECTED] wrote:
> > Guten Tag Donna Robinson,
> Hi 2u2 sir!
> and god bless your cotton socks.
>
> > i hope this will help you..
> ...
> it didn't but it gave me enough of a clue so that this did:
> select dancedetails.coupletypes.*
> fro
> Guten Tag Donna Robinson,
Hi 2u2 sir!
and god bless your cotton socks.
> i hope this will help you..
...
it didn't but it gave me enough of a clue so that this did:
select dancedetails.coupletypes.*
from dancedetails.coupletypes
left join dancedata2.couples
on dancedetails.coupletypes.name=d
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,
