Setting up foreign key constraints in phpMyAdmin.

[surinder]

Where is Foreign key in phpmyadmin

[r035198x]

Where is Foreign key in phpmyadmin

The question doesn't make much sense like that? If you are getting an error then post the error message you are getting. If you are unclear about some concept then try rephrasing your question.

[pbmods]

Heya, Surinder.

Changed thread title to better describe the problem (did you know that threads whose titles do not follow the Posting Guidelines actually get FEWER responses?).

phpMyAdmin does not handle foreign keys. To set up foreign key constraints on your InnoDB tables, you need to issue the SQL directly.

[samuel123]

Dear All ,
This is my first post on this forum and seeking the solution of a problem. Hope, I would certainly get from the forum.


Say, I have got Two tables. Those are..

1. users
Field in users: user_id(pk)

2. commitment
Field in commitment: user_id(fk for commitment table)

A. My question is: How should I set the relation between users and commitment tables in Phpmyadmin?

But I did the relation in commitment table this way but I am not sure of it.

commitment
---------------
foreign key(user_id) references users(user_id); 
Is this way that can I show relation between users and commitment ?

Your help would be greately.. praised.


Thank you very much for the help in advance
Samuel

[f1codz]

I have posted in details the steps required to enable setting foreign keys in phpmyadmin here : http://imdad.wordpress.com/2008/07/24/foreign-key-in-phpmyadmin-xampp/