Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Is it possible to query multiple MySQL db's in one query?

Status
Not open for further replies.
Spijker

Spijker

Programmer
Jan 9, 2001
10
0
0
NZ
I am trying to extract information from two seperate tables from 2 different MySQL databases on the same server. Is this possible, and if so what would be the best way to go about it.

 
Sort by date Sort by votes
Yes. Just make the database name a prefix to your fields:
Code: 
SELECT db1.table1.field1, db2.table2.field2
FROM db1.table1, db2.table2

-Rob
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

EdLentz
  • Locked
  • Question
How do I use a keyword in a query??
Replies
6
Views
138
EdLentz
EdLentz
lupidol
  • Locked
  • Question
Cannot create new table in mySQL 3
Replies
6
Views
134
lupidol
lupidol
dylim
  • Locked
  • Question
Why MySQL 5.7 is still getting updates
Replies
3
Views
84
spamjim
spamjim
AbidingDude
  • Locked
  • Question
One Constraint for Multiple Columns 1
Replies
2
Views
81
AbidingDude
AbidingDude
dylim
  • Locked
  • Question
SQL_CALC_FOUND_ROWS still runs in MySQL 8.0.29
Replies
2
Views
125
dylim
dylim

Part and Inventory Search

Sponsor

Back
Top