If MySql does not implement foriegn keys, how is it relational. What I\'m saying may be made clearer in the following example:
I have a student_id in two seperate tables, one is the primary key the other is the foriegnkey. If I change the primary key (students id number) I expect the foriegn to reflect this change. I don\'t want to have to update both tables.
Can someone tell me how to do this in MySQL, if not what is the closest thing to it in MySQL.
