Page 1 of 1

making a select on 2 diffrent DB

Posted: Wed Aug 18, 2004 9:22 am
by pelegk2
i have 2 diffrent DB
1 calles prod an have a table that called user
and another db called com with a table called users
and i want to check which user appear on them both!
is it possible to do it?
thnaksi nadvance
peleg

Posted: Wed Aug 18, 2004 9:36 am
by Buddha443556
from MYSQL wrote:You can refer to a table within the current database as tbl_name (within the current database), or as db_name.tbl_name to explicitly specify a database. You can refer to a column as col_name, tbl_name.col_name, or db_name.tbl_name.col_name. You need not specify a tbl_name or db_name.tbl_name prefix for a column reference unless the reference would be ambiguous. See section 10.2 Database, Table, Index, Column, and Alias Names for examples of ambiguity that require the more explicit column reference forms.
I use this notation just in case a customer drops a whole new database on me. Again.