mysql - How can you create a foreign key to a table in another database with workbench? -


in mysql, using mysql workbench, how can create foreign key relationship table resides in database? after entering 'qualified table name', of databasename.tablename.columnname, workbench acts put nothing in box. need create these relationships manual query in workbench if different database?

innodb engine allows define fk(foreign key) tables.(even other databases)

for must mention database name before table , column name. :

dbname.tablename.columnname 

Comments

Popular posts from this blog

assembly - 8086 TASM: Illegal Indexing Mode -

java - How to create a Servlet Filter in Eclipse in the absence of web.xml? -

javascript - addthis share facebook and google+ url -