MySQL Forums
Forum List  »  Newbie

Re: 1005 - Can't create table
Posted by: Daniel Isaacs
Date: July 28, 2005 03:21AM

no i havent
now with this

ALTER TABLE container_data_int
ADD CONSTRAINT container_data_int
FOREIGN KEY(DataID) REFERENCES
DATA(DataID)
ON UPDATE CASCADE

is sending me an error.. however this statement work for me
ALTER TABLE container_data_int
ADD CONSTRAINT container_data_int
FOREIGN KEY(ContainerID) REFERENCES
CONTAINER(ContainerID)
ON UPDATE CASCADE

i dont think there is any difference

Options: ReplyQuote


Subject
Written By
Posted
Re: 1005 - Can't create table
July 28, 2005 03:21AM


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.