Calling another database?

[ted björling]

Hi!

I've encountered an issue using foreign keys with mysql: is it possible to call
another local database from within a table of a database? For example, if I've
got a database consisting of car manufacturers and another one consisting of
retailers, then I'd like to have the retailer database to reference the manufacturer
database in some way. For example:

CREATE TABLE retailer1 (
FOREIGN KEY car TEXT REFERENCES manufacturer.cars(car) ON DELETE CASCADE
ON UPDATE CASCADE;
) TYPE INNODB;

This way I hope to be able to have the retailer database up-to-date.
Is it possible to reference another database in this manor? How do I do it in that case?

yours sincerely
ted b