List:General Discussion« Previous MessageNext Message »
From:Dicky Wahyu Purnomo Date:September 4 2002 3:55am
Subject:Re: Cross Database Table Join
View as plain text  
Pada Tue, 3 Sep 2002 19:28:33 -0400
"Bob Davis" <rcdavis@stripped> menulis :

> I'm trying to do a cross database mysql query. Does anyone know of a way to
> do this? I've looked through all the documentation I can find including
> release 4.0.

what kind of query do want to do ?

shell> mysql -p DB_A
mysql> select * from DB_B.Table_B1;

it's crossing other DB ;-)

-- 
Let's call it an accidental feature.
	-- Larry Wall
 
MySQL 3.23.51 : up 75 days, Queries : 358.102 per second (avg).

--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan 12790
Phone : +62 21 79199577 - HP : +62 8551044244 - Web : http://www.1rstwap.com

Thread
Cross Database Table JoinBob Davis4 Sep
  • Re: Cross Database Table JoinDicky Wahyu Purnomo4 Sep