Select columns across different databases

by

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

More Related Contents:

  1. how to get result form mysql query in specific ids [closed]
  2. mysql error cant fix the error [duplicate]
  3. Why can’t this entry be added because of Foreign Key error?
  4. MySQL pivot row into dynamic number of columns
  5. MySQL server startup error ‘The server quit without updating PID file’
  6. MySQL AUTO_INCREMENT does not ROLLBACK
  7. Best type of indexing when there is LIKE clause [duplicate]
  8. What’s the difference between MyISAM and InnoDB? [duplicate]
  9. Create new user in MySQL and give it full access to one database
  10. Most efficient way to get table row count
  11. Allow all remote connections, MySQL
  12. Import CSV to MySQL
  13. MySQL automatically cast/convert a string to a number?
  14. How to select rows that have current day’s timestamp?
  15. What’s the best database structure to keep multilingual data? [duplicate]
  16. LEFT JOIN only first row
  17. MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
  18. How to hack MySQL GROUP_CONCAT to fetch a limited number of rows?
  19. MySQL connection over SSH tunnel – how to specify other MySQL server?
  20. Storing IPv6 Addresses in MySQL
  21. How to determine which database is selected
  22. How to remove constraints from my MySQL table?
  23. Defining Composite Key with Auto Increment in MySQL
  24. How to use Table output from stored MYSQL Procedure
  25. Get total hours worked in a day mysql
  26. SQL (MySQL) vs NoSQL (CouchDB) [closed]
  27. MySQL GROUP BY age range including null ranges
  28. Best tool for synchronizing MySQL databases [closed]
  29. Failed building wheel for mysql-python
  30. How to convert a varchar column type to date type without losing the dates

Leave a Comment