phpmyadmin and table Relationships

[lminmei]

OK...does anyone have any idea how I can create primary and foreign key relationships in phpMySQL Admin for MySql?
If there isn't a way to do that in phpMyAdmin, is there
another front end to let me create relationships in MySql?

please help,
thanx,
-derek

 

[sonnysavage]

Foreign keys are software dependant in MySQL, which is why phpMyAdmin doesn't provide that functionality. I'm not aware of any MySQL front-end that supplies this functionality.

 

[lminmei]

What do you mean by software dependent? I don't understand what you mean by that. So how do i create table relationships in MySql then?

 

[sonnysavage]

What I meant was: "You can have columns in a table that are foreign keys, but your software has to manage the contraints. For example, MySQL would allow you to put a bogus ID into a foreign key."

But, I was mistaken. I just did a search of "foreign key" on the

http://www.mysql.com/

web site, and found this:

http://www.mysql.com/doc/S/E/SEC446.html

The table with a foreign key, and the table referenced by the foreign key both have to be of type "InnoDB". Now I know that phpMyAdmin will allow you to set the table type, but I don't know how it handles foreign keys.

Anyone else?