Re: foreign key

[Atul Singh]

First of all you will have to check out which version you are using. Older versions of mysql do not support refrential integrity. You can create a foreign key like this

CREATE TABLE users (id INT NOT NULL,
PRIMARY KEY (id)
);
CREATE TABLE profiles (id INT, users_id INT,
INDEX usr_ind (users_id),
FOREIGN KEY (users_id) REFERENCES users(id)
ON DELETE CASCADE
);

I dont't exactly remember in which version refrential integrity introduced. But i am using version 5.0 which is quite stable as of now and supports refrential integrity