Using two databases in a query?

dreq jkj Thu, 20 Mar 2003 08:05:23 -0800

Is it possible to use multiple databases in a query? (Privided that the user has correct permissions, that is)

I have tried to use mysql as root and make a such query, and got a result. The result, however, did look very strange.

database ccs_db.ccs_admin:
userID int unsigned....
username...

database jobbguiden.jobbguiden_admin_user:
id int
username varchar(...)

Using select: select jobbguiden.jobbguiden_admin_user.username, ccs_db.ccs_admin.username, ccs_db.ccs_admin.adminID from ccs_db.ccs_admin left join jobbguiden.jobbguiden_admin_user on(ccs_db.ccs_admin.adminID=jobbguiden.jobbguiden_admin_user.id);

Result:
+----------+--------------+---------+
| username | username     | adminID |
+----------+--------------+---------+
| mall     | autorun      |       1 |
| stefan   | dbtransfer   |       2 |
| NULL     | staffan grön |       3 |
   |       4 |tarina
    |       5 |ffan
       |       6 |
       |       7 |
           |       8 |
      |       9 |
     |      10 |ha
     |      11 |an
     |      12 |el
     |      13 |an
     |      14 |el
     |      15 |ik
     |      16 |le
     |      17 |na
     |      18 |ny
       |      19 |
   |      20 |signer
+----------+--------------+---------+

All usernames from ccs_db has been trunkated in a strange manner...
Is this action completly un-supported, but semi-working...?

Btw; I'm running mysql 4.0.1-alpha...

//drew


_________________________________________________________________
Hitta rätt på nätet med MSN Sök http://search.msn.se/


---------------------------------------------------------------------
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Using two databases in a query?

Reply via email to