Hi,

I would like to make a connection between 2 databases in
MySQL that are on the same server. 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.

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?

I hope I was clear enough...

Greetings,

Bart


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to