How to add a foreign key in mysql using phpmyadmin

How to add a foreign key in mysql using phpmyadmin
To add a foreign key in MySQL using phpMyAdmin, you can follow these steps:

Open phpMyAdmin: Access phpMyAdmin by visiting the URL of your web server followed by "/phpmyadmin" (e.g., http://localhost/phpmyadmin).

Select the Database: On the left-hand side, click on the database name where you want to add the foreign key.

Choose the Table: Click on the table name where you want to add the foreign key. If the table doesn't exist, you'll need to create it first.

Go to "Structure" Tab: Within the table view, click on the "Structure" tab at the top of the page. This will show the structure of the table.

Add Foreign Key Column: Locate the column where you want to add the foreign key. If the column doesn't exist, create it by clicking on the "+ Add" button or by editing an existing column.

Configure Foreign Key: In the "Structure" tab, find the column where you want to add the foreign key and click on the "Relation view" icon. It typically looks like a link or a chain.

Define Foreign Key Relationship: In the "Relation view" section, you'll see options to configure the foreign key relationship.
Choose the "Foreign key constraint" option and select the column that references the primary key in the parent table.
Set the "Foreign key name" to a meaningful name for the foreign key constraint.
Choose the appropriate "On Delete" and "On Update" actions, specifying how the foreign key should behave when the referenced row is deleted or updated.

Save Changes: After configuring the foreign key relationship, click the "Save" or "Apply" button to save the changes.

Verify Foreign Key: To verify that the foreign key was added successfully, you can check the table structure in the "Structure" tab. The column with the foreign key should now be displayed with the appropriate relationship details.

It's important to ensure that the referenced column in the parent table is a primary key or has a unique index defined. If not, you may need to add the necessary index before adding the foreign key.

By following these steps, you should be able to add a foreign key in MySQL using phpMyAdmin. Make sure to review and test the changes to ensure the foreign key constraint is functioning correctly.