How to add on delete cascade and on update restrict using phpmyadmin?

Question

I want to add 'On delete cascade and on update restrict' on foreign keys through phpmyadmin user Interface instead of executing query.

I generally use Heidisql control panel for doing these actions. And now I'm having hard time doing the same on phpmyadmin.

Any idea?

Answer 1

In the tab where you define the table structure, you get the list of columns and their properties and underneath that there should be a link "relation view", between "print view", and "propose table structure."

That's where you want to go, but you have to have created the index on both tables already. Also, you might want to make sure you're using mysql's innoDB storage engine.

Edit : An image is worth 1000 words :