[thelist] selecting tables from two databases

Michiel Trimpe M.B.Trimpe at student.tue.nl
Thu Apr 25 12:35:01 CDT 2002


Hello David,

If they're on the same MySQL server process and the user has
privileges for both databases you can use the database.table syntax.
The other mail said database..table but I suppose that that's MS SQL
specific as he stated.

GL,
  Michiel Trimpe

<snip>
DK> With a current client, I've run into a bit of a problem in migrating their old, proprietary backoffice system into an integrated web-based system.  In essense, to avoid recoding a whole ton of
DK> stuff, it would be advantageous if I could create a method that, whichout too highly taxing the system resources, would allow for a mysql query from two local databases.
</snip>





More information about the thelist mailing list