MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

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

actually i'm having trouble with this statement
somehow i drop the table and create it again
and it worked...i'm using mysql query browser 1.1
and this statement doesnt work for me

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


and i get this cant create table message

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
1005 - Can't create table
Daniel Isaacs
July 28, 2005 01:40AM
Re: 1005 - Can't create table
Roland Bouman
July 28, 2005 03:05AM
Re: 1005 - Can't create table
Andrew Gilfrin
July 28, 2005 03:18AM
Re: 1005 - Can't create table
Daniel Isaacs
July 28, 2005 03:21AM
Re: 1005 - Can't create table
Daniel Isaacs
July 28, 2005 03:19AM


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.