PhpMyAdmin: How Do You Set Foreign Keys?

How do you set foreign keys with PhpMyAdmin?

I know the tables must be INNODB. And I read somewhere that the columns which will be used as foreign keys must be indexes. Is that true? If so, must these columns be made indexes on the child or parent table?

Basically, I'm completely confused. If you know, please explain clearly, and I'll add some points to your account.

 

I've just found a set of instructions explaining how to do this quite clearly.

 

If you're looking for an easier way to manage a mysql DB try navicat. It makes managing a DB so much easier than phpmyadmin. You can see the exact foreign key relationships with every table as well as managing stored procedures, views, backups, and everything else.

 

Thanks for the advice. Sounds good . . . I might have to try it.