Member Avatar for Henryu

I'm tyring to figure out a way to compare the information in 2 different tables from 2 different databases. If they are in the same database it's easy enough but I haven't found a way to do it from 2 different databases.

  • 2 Contributors
  • 1 Reply
  • 247 Views
  • 2 Hours Discussion Span
  • Latest Post Latest Post by jkon
Member Avatar for jkon

Hello Henryu,

Although in the PDO DB connection object constructor you define the default schema there is nothing stopping you from selecting from other one or using JOIN with two different schemas in the same server as long as:
A: The user has sufficient privileges in both schemas
B: You add the schema prefix (with dot) before the table name (e.g. example_db.categories)

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.