List:General Discussion« Previous MessageNext Message »
From:<jc Date:May 14 2010 6:03pm
Subject:RE: Can't create foreign key
View as plain text  
Nope, that wasn't the problem.  I wasn't aware that the foreign key name
must be unique. So, if you have a foreign key named "fk_lesson", that same
name cannot exist already, even if on a different table.  I named the
foreign key something completely different and that solved the problem.

Jesse

-----Original Message-----
From: Carsten Pedersen [mailto:carsten@stripped] 
Sent: Friday, May 14, 2010 1:49 PM
To: jc@stripped
Cc: mysql@stripped
Subject: Re: Can't create foreign key

Haven't done this in a while, but I'm guessing that you can't create 
both a constraint and an index with the same name?

Type mismatch will in my experience most often generate an errno 150.

/ Carsten

jc@stripped skrev:
> I'm trying to create a foreign key by executing the following statement:
> 
> ALTER TABLE `cc`.`takenlessons` 
> 
>   ADD CONSTRAINT `fk_lessons`
> 
>   FOREIGN KEY (`LessonID` )
> 
>   REFERENCES `cc`.`lessons` (`id` )
> 
>   ON DELETE CASCADE
> 
>   ON UPDATE NO ACTION
> 
> , ADD INDEX `fk_lessons` (`LessonID` ASC) ;
> 
>  
> 
> I'm using the RC of MySQL workbench to do this. When I execute this
> statement, I get the following error:
> 
> Error Code: 1005
> 
> Can't create table 'cc.#sql-115c_61' (errno: 121))
> 
>  
> 
> In the past when I got a similar error, it was because the fields didn't
> match exactly. For instance, one may be Int(10) and one Int(11), or one
may
> be Unsigned, and the other not.  But, in this case, both match exactly.
> What other reasons are there for a foreign key creation to fail like that?
> 
>  
> 
> Thanks,
> 
> Jesse
> 
> 
> 
> !DSPAM:451,4bed85fe818443309765824!
> 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1



Thread
Can't create foreign keyjc14 May
  • RE: Can't create foreign keyGavin Towey14 May
    • RE: Can't create foreign keyjc14 May
  • Re: Can't create foreign keyCarsten Pedersen14 May
    • RE: Can't create foreign keyjc14 May
      • Re: Can't create foreign keyPrabhat Kumar14 May