Mysql query to fetch data from two databases of two different host

Question

A query or stored procedure to get data from two databases. First get data from school database which is in host1

USE school;
SELECT id FROM student WHERE marks > 80;

With the result of first query from host2, admin database

Use admin;
SELECT * FROM student_details WHERE id IN (result from first db)

score 0 · Answer 1 · answered Aug 05 '22 at 11:30

0

You're almost there

SELECT 
  * 
FROM
  admin.student_details sd 
WHERE sd.id IN 
  (SELECT 
    s.id 
  FROM
    school.student s 
  WHERE s.marks > 80)

It would be a lot better if you provided some of the sample table, data and your required output

answered Aug 05 '22 at 11:30

Asgar

Sorry its actually database from two different host – Cork Kochi Aug 05 '22 at 12:03
See [this](https://stackoverflow.com/questions/810349/mysql-cross-server-select-query) – Asgar Aug 05 '22 at 12:05

1 Answers1