MySQL Forums
Forum List  »  InnoDB

adding forign key
Posted by: jobin and
Date: December 29, 2006 07:47AM

Dear Sir,

I have 10 tables in my database
I can't add forign key to that tables. Query is running but displaying "0 records affected". pls give me a help.

...query...

ALTER TABLE visit
ADD CONSTRAINT web_f
FOREIGN KEY(site_id)
REFERENCES user(site_id)

Options: ReplyQuote


Subject
Views
Written By
Posted
adding forign key
7300
December 29, 2006 07:47AM
3319
January 04, 2007 12:54PM
3284
February 16, 2007 03:48PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.