Adding constraints in phpMyAdmin

mysql foreign-keys phpmyadmin relational-database
Alex picture Alex · Feb 29, 2012 · Viewed 37.1k times · Source

I feel like I'm being stupid, but I can't find anywhere on the phpMyAdmin interface to add constraints to foreign keys e.g. CASCADE ON DELETE

I've looked for similar questions on here and on the phpMyAdmin wiki but I can't find anything about it.

I realise I could do this via the query interface, but I'd like to know how to do it through the graphical interface.

Answer

utsikko picture utsikko · Feb 29, 2012

First, you should have your storage engine as InnoDB. Then select a table and go to 'Structure' tab.

Under the table you will see 'Relation view', click it. From there you could add constraints.

Related questions

how do I add a foreign key pointing to the same table using phpMyAdmin?

I have an existing InnoDB table which already has foreign keys pointing to different tables. But when I try to create a foreign key pointing to the Primary index, I get an error (check data type). The table is User …

Read More
Add Foreign Key to existing table

I want to add a Foreign Key to a table called "katalog". ALTER TABLE katalog ADD CONSTRAINT `fk_katalog_sprache` FOREIGN KEY (`Sprache`) REFERENCES `Sprache` (`ID`) ON DELETE SET NULL ON UPDATE SET NULL; When I try to do this, …

Read More
How to truncate a foreign key constrained table?

Why doesn't a TRUNCATE on mygroup work? Even though I have ON DELETE CASCADE SET I get: ERROR 1701 (42000): Cannot truncate a table referenced in a foreign key constraint (mytest.instance, CONSTRAINT instance_ibfk_1 FOREIGN KEY (GroupID) REFERENCES mytest.mygroup (ID)) …

Read More