MySQL InnoDB foreign key between different databases

by

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.

More Related Contents:

  1. MyISAM versus InnoDB [closed]
  2. MySQL foreign key constraints, cascade delete
  3. How do I see all foreign keys to a table or column?
  4. How do I quickly rename a MySQL database (change schema name)?
  5. How to shrink/purge ibdata1 file in MySQL
  6. What’s the difference between MyISAM and InnoDB? [duplicate]
  7. MySql: MyISAM vs. Inno DB! [closed]
  8. Force InnoDB to recheck foreign keys on a table/tables?
  9. Meaning of “n:m” and “1:n” in database design
  10. MySQL foreign key to allow NULL?
  11. How do I rename a MySQL database (change schema name)?
  12. Why doesn’t MySQL’s MyISAM engine support Foreign keys?
  13. Foreign key constraints: When to use ON UPDATE and ON DELETE
  14. MySQL DROP all tables, ignoring foreign keys
  15. Implementing Comments and Likes in database
  16. How to check if mysql database exists
  17. difference between primary key and unique key
  18. MySQL: Cloning a MySQL database on the same MySql instance
  19. DOs and DONTs for Indexes [closed]
  20. How to change the default port of mysql from 3306 to 3360
  21. Is it possible to reference one column as multiple foreign keys?
  22. How to insert images from database?
  23. Alternative to using LIMIT keyword in a SubQuery in MYSQL
  24. Find date range overlaps within the same table, for specific user MySQL
  25. How to store Query Result in variable using mysql
  26. How to reuse auto_increment values? [duplicate]
  27. How do I alter a mysql table column defaults?
  28. Selecting distinct 2 columns combination in mysql
  29. MySQL – Complexity of: SELECT COUNT(*) FROM MyTable;
  30. MySQL and PDO: Could PDO::lastInsertId theoretically fail?

Leave a Comment