Inserting data into a MySQL table using PHPMyAdmin

2.8k views Asked by At

This is a bit of a newb question, so apologies if the answer is really obvious. I have a bunch of InnoDB MySQL tables set up with Foreign Key restraints. This is all fine, as far as I can tell, however I'd like to use it to insert data into the database.

I was hoping I would be able to use a dropdown menu, since I should, in theory, be unable to enter any data into the Parent table that the Child table doesn't already have.

Unfortunately this is all I see when I'm in the Parent table:

enter image description here

There is nothing to allow me to choose data from the child tables.

How do I use this feature? And is it possible to see the contents of a different column (e.g. When picking "EventID" being able to see "EventName" from the same table?).

I'm kind of hoping that I'm not just going to have to write a .php page to do the same thing.

Thanks a lot.


Update: When exported the FK declarations look like this (i.e. fine, as far as I can tell):

ALTER TABLE `Nominations`
  ADD CONSTRAINT `Nominations_ibfk_1` FOREIGN KEY (`FilmID`) REFERENCES `Films` (`FilmID`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `Nominations_ibfk_2` FOREIGN KEY (`AwardID`) REFERENCES `Awards` (`AwardID`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `Nominations_ibfk_4` FOREIGN KEY (`EventID`) REFERENCES `Events` (`EventID`) ON DELETE CASCADE ON UPDATE CASCADE;
0

There are 0 answers