MySQL foreign key in a table in another database?

Question

Is it possible to bind (InnoDB) a foreign key in another database in MySQL?

Is this a bad practice?

Answer 1

Yes, it is possible on the same database server. The database name prefix when adding a constraint, for example. databasename.tablename.fieldname . Observe user permissions.

I do not consider this a bad practice, although this is not something that should happen very often.

Answer 2

Yes, you can use the foreign key link in another database in MYSQL.

Thanks.