Member Avatar for sakurayana

hye friends.....
i need your help.....does anyone know how to select 2 databases simultaneously?i want to select certain data from database 1 and database 2.please help me for this....thanks in advance....

  • 2 Contributors
  • 1 Reply
  • 93 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by destruct0

Dani AI

Generated

: selecting from two databases on the same MySQL server is simple—use fully qualified names (database.table). pointed to the SELECT docs; below are concrete, ready-to-run patterns and a few troubleshooting notes.

Example: join tables that live in two databases on the same server

SELECT a.id, a.name, b.score
FROM db1.users AS a
INNER JOIN db2.scores AS b ON a.id = b.user_id;

Example: combine rows from two databases that have the same table structure (use UNION or UNION ALL)

SELECT id, name, 'db1' AS src
FROM db1.customers
UNION ALL
SELECT id, name, 'db2' AS src
FROM db2.customers;

Quick tips and common pitfalls:

  • Both databases must be on the same MySQL server instance. If they are on different servers, a direct SQL join is not possible without a solution such as the FEDERATED/CONNECT engine, replication, or doing the join in the application layer or an ETL step.
  • The MySQL account must have privileges on both databases. A common error is "Access denied" or "Unknown database". Use GRANT SELECT ON dbname.* TO 'user'@'host'; if privilege changes are needed.
  • Quote names with backticks if a database or table name contains special characters or is a reserved word.
  • For large tables, make sure join columns are indexed and use EXPLAIN to inspect the query plan to avoid full-table scans.

These patterns cover most needs when selecting across databases on the same server.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.