Page 1 of 1

FK question

Posted: Wed Nov 05, 2008 10:29 am
by crazycoders
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?