brianmfalls
asked on
MySql Workbench outputting "OK" as result of queries.
I am running a simple query to see if a first name/last name pair on a list, TableB, can be found in a large table of 3.8 million records.
The query returns "OK" after about 20 minutes.
I have never seen that result and have trouble finding documentation about what it means. I eventually have to run a match on ten fields across three tables in separate databases so I'm disapointed that it failed in an indecipherable way on my test run.
SELECT
id,
'Highly likely' AS 'Match Level'
FROM
`SchemaA`.`TableA` n
WHERE
(n.`FieldA` IN
(
select distinct fflp.`FieldA`
from `SchemaB`.`TableB` fflp
)
)
AND
(n.`FieldB` in
(
select distinct fflp.`FieldB`
from `SchemaB`.`TableB` fflp
)
);
The query returns "OK" after about 20 minutes.
I have never seen that result and have trouble finding documentation about what it means. I eventually have to run a match on ten fields across three tables in separate databases so I'm disapointed that it failed in an indecipherable way on my test run.
SELECT
id,
'Highly likely' AS 'Match Level'
FROM
`SchemaA`.`TableA` n
WHERE
(n.`FieldA` IN
(
select distinct fflp.`FieldA`
from `SchemaB`.`TableB` fflp
)
)
AND
(n.`FieldB` in
(
select distinct fflp.`FieldB`
from `SchemaB`.`TableB` fflp
)
);
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the help guys!
ASKER
Action Output:
15:03:05/ SELECT `id`, 'Highly likely' AS 'Match Level' FROM `SchemaA`.`TableA` n WHERE (n.FieldA IN ( select distinct fflpA.FieldA from `SchemaB`.`TableB` fflpA ) ) AND (n.FieldB in ( select distinct fflpB.FieldB from `SchemaB`.`TableB` fflpB ) ) / OK / 561.500 sec