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

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 :
highlighted a few buttons in phpmyadmin interface

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)