How to Retrieve Data from Two Different MySQL Database using JDBC?

Question

How to retrieve data from two different MySQL database in a single query using jdbc?

SELECT 
      a.`driver_id`,
      a.`state`, 
      a.`lat`, 
      a.`long`, 
      MAX(a.`time_stamp`) AS timestamp,
      b.vehicle_type 
 FROM `rl_driv_location` AS a, `rl_driver_info` AS b 
 WHERE a.`state` = 1 AND a.`driver_id` = b.`user_id` 
       AND b.`vehicle_type` = '"+ cartype +"'  
 GROUP BY driver_id

location database having the rl_driv_location table.
core database having the rl_driver_info table.

Rigel1121 · Accepted Answer · 2015-02-13 05:37:30Z

1

Just specify the name of the databases where you want to retrieve data. See below.

SELECT 
      a.`driver_id`,
      a.`state`, 
      a.`lat`, 
      a.`long`, 
      MAX(a.`time_stamp`) AS timestamp,
      b.vehicle_type 
 FROM location.`rl_driv_location` AS a, core.`rl_driver_info` AS b 
 WHERE a.`state` = 1 AND a.`driver_id` = b.`user_id` 
       AND b.`vehicle_type` = '"+ cartype +"'  
 GROUP BY driver_id

answered Feb 13, 2015 at 5:37

Rigel1121

2,0171 gold badge19 silver badges25 bronze badges

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

2 Comments

Innovative Thinker Over a year ago

how to modify the db url : static final String DB_URL = "jdbc:mysql://localhost/core";

Rigel1121 Over a year ago

Read this one, it will help you: stackoverflow.com/questions/8491729/…

Collectives™ on Stack Overflow

How to Retrieve Data from Two Different MySQL Database using JDBC?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related