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]