Navicatfor in MySQL Add foreign key method

Environment: Navicatformysql 8.2 + MySQL Sever 5.1

Problem: Add foreign key in Navicatformysql

Solution

Method One:

To create a foreign key by using an SQL statement:

ALTER TABLE FOREIGN KEY table add constraint constraint

name foreign key (field name) references reference table (foreign key field name) on delete restrict/set Null/cascade 

on Update Restrict/set Null/cascade;

Without specifying the name of the foreign key, MySQL will automatically create a foreign key name for you:

ALTER TABLE FOREIGN key table add foreign key (field name) references reference table (foreign key field name) on delete 

restrict/set null/cascade on update restrict/set Null/cascade;

Method Two:

Use the graphical interface.

Select Table-------> Right-------> Design table-------> Foreign key-------> Fill Options.