Add a foreign key to Navicatfor Mysql

Environment for adding Foreign keys to Navicatfor Mysql: NavicatforMysql 8.2 + MySQL Sever 5.1
Problem: Add a foreign key to NavicatforMysql:
Method 1: use an SQL statement to create a foreign key: [SQL] alter table foreign key table add constraint name foreign key (column name) references reference table (foreign key column name) on delete restrict/set null/cascade on update restrict/set null/cascade; if the foreign key name is not specified, mysql will automatically create a foreign key name for you: www.2cto.com [SQL] alter table foreign key table add foreign key (column name) references reference table (foreign key column name) on delete restrict/set null/cascade on update restrict/set null/cascade; Method 2: Use the graphic interface. Select Table -------> right-click -------> design table -------> foreign key -------> enter option. References: http://www.bkjia.com/database/201207/139316.html author Wentasy