Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Select columns across different databases

Tags:

mysql

Is it possible to do a select ( or insert) statement across different databases that are located on the same server? If yes, how?

like image 595
Graviton Avatar asked Mar 23 '09 16:03

Graviton

People also ask

Can you query from multiple databases?

It is possible to use SQL to write one query that combines the information from many databases. There are two requirements: You must prefix all table references with the database name (e.g. customers.

How do you run a SQL query across multiple databases with one query?

Open a new Query Window and write a query which has to be executed against multiple database of a server. Right click in the window and Select an option “Run On Multiple Targets” as shown below. This will open a new window which will have all the database available on the current server listed as shown below.

1 Answers

You would specify the database by using the syntax databasename.tablename

Example:

SELECT      mydatabase1.tblUsers.UserID,      mydatabse2.tblUsers.UserID FROM     mydatabase1.tblUsers        INNER JOIN mydatabase2.tblUsers             ON mydatabase1.tblUsers.UserID = mydatabase2.tblUsers.UserID
like image 197
TheTXI Avatar answered Sep 23 '22 11:09

TheTXI
Sign in to Comment

Related questions

Git Bash mysql blank
Hibernate JPA, MySQL and TinyInt(1) for Boolean instead of bit or char
How can I convert a string to a float in mysql?
use mysql SUM() in a WHERE clause
Copy mysql database from remote server to local computer
How to take complete backup of mysql database using mysqldump command line utility
MySQL order by "best match"
Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root
How can I add an INDEX with Doctrine 2 to a column without making it a primary key?
Delete all rows with timestamp older than x days
Parse date in MySQL
GROUP_CONCAT with limit
How to retrieve SQL result column value using column name in Python?
Insert and set value with max()+1 problems
Get records of current month [duplicate]
MySQL IFNULL ELSE
Multiple Table Select vs. JOIN (performance)
Unique key with NULLs
Does dropping a table in MySQL also drop the indexes?
Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!