Link to home
Start Free TrialLog in
Avatar of brianmfalls
brianmfallsFlag for United States of America

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
        )
      );
ASKER CERTIFIED SOLUTION
Avatar of hielo
hielo
Flag of Wallis and Futuna image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of brianmfalls

ASKER

I tried it.  Got the same failure.  

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
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks for the help guys!