Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

MySQL InnoDB foreign key between different databases

Tags:

database

mysql

innodb

foreign-keys

I would like to know if it's possible in InnoDB in MySQL to have a table with foreign key that references another table in a different database ?

And if so, how this can be done ?

like image 344
Alaa Avatar asked Oct 11 '10 09:10

Alaa

People also ask

Can you have a foreign key to a different database?

Since you want to keep all the business rules in the database your first thought is to use a Foreign Key constraint between the two databases, but when you try to create a foreign key between the two tables on the different databases you quickly learn that it is not possible.

Does InnoDB support foreign keys?

InnoDB does not currently support foreign keys for tables with user-defined partitioning. This includes both parent and child tables.

Can a foreign key reference multiple tables MySQL?

No problem at all.

Can a table contain multiple foreign key's?

A table can have multiple foreign keys based on the requirement.

1 Answers

I do not see any limitation on https://dev.mysql.com/doc/refman/8.0/en/create-table-foreign-keys.html.

So just use otherdb.othertable and you will be good.

like image 71
BarsMonster Avatar answered Oct 04 '22 04:10

BarsMonster
Sign in to Comment

Related questions

How does one create an index on the date part of DATETIME field in MySql
How to conduct an Accent Sensitive search in MySql
How to raise an error within a MySQL function
MySQL command line formatting with UTF8
What is the advantage of using try {} catch {} versus if {} else {}
How do I use properly CASE..WHEN in MySQL
How to rearrange MySQL columns?
WooCommerce: Finding the products in database
Can I use VARCHAR as the PRIMARY KEY?
How to use NOT IN clause in sqlalchemy ORM query
Best way to check if mysql_query returned any results?
How do I add two count(*) results together on two different tables?
MySQL vs PostgreSQL? Which should I choose for my Django project?
PHP MYSQL UPDATE if Exist or INSERT if not?
MySQL, coalesce equivalent for empty values?
Laravel 5 Querying with relations causes "Call to a member function addEagerConstraints() on null" error
SQLite - ORDER BY RAND()
Loading .sql files from within PHP
Laravel OrderBy relationship count
What the difference between mysql and mysql2 gem

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!