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)

Asgar · Accepted Answer · 2022-08-05 11:30:16Z

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 5, 2022 at 11:30

Asgar

2,4102 gold badges10 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Sorry its actually database from two different host