phpMyAdmin

Converting tables into innodb

The innodb storage engine supports foreign keys in Mysql.

Open your database, and run this query:

ALTER TABLE table_name ENGINE = InnoDB;

Creating foreign keys

Convert both tables into innodb, if they are not already.

View the structure of the table which will have a foreign key. Make the referencing field an INDEX.

Now come back to structure view and click Relation view.

Point your foreign keys to the corresponding column names.

Learning Resources

  • Create foreign key using Phpmyadmin article.