I have a mysql server running client version 5.0.22 (not sure what version of server but it must be close) and phpmyadmin 2.8.2.4 (Comes with Plesk 8.3)
In any table structure, i am able to access "Relation View". This button to my knowledge should only appear if my tables are InnoDB because MyISAM doesn't support relationships. After setting those relationships, i am able to save them and if i come back to the panel they are indeed saved because they are shown back. Finaly, if i go and insert a row into the table, i get little icons beside the field allowing me to select a foreign value. Inputting anything invalid still goes through...
So what is this anyway? If it really a kind of foreign key relationships? It doesn't show anywhere in the create statements. I think it's something to do with phpmyadmin only and has nothing to do with mysql, could i be right?
FK question
Moderator: General Moderators
-
crazycoders
- Forum Contributor
- Posts: 260
- Joined: Tue Oct 28, 2008 7:48 am
- Location: Montreal, Qc, Canada