* Steijn, B.S. > I would like to make a connection between 2 databases in > MySQL that are on the same server.
If you by "connection" mean to join tables from the two databases on the same server, you can do that. > The purpose is that a > class X in database A uses a class Y in database B by a > foreign key. Thus, the table in B can be re-used by other > databases which will make my databases more efficient. Right. > I've already thought of a solution like FOREIGN KEY c_id > REFERENCES A.customer(c_id)ON DELETE CASCADE but I think > this will not work. Is there any other solution to do this? Right, this will not work. But this is a foreign key constraint, you don't need a constraint to make a join work. -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]