MySQL Lists: mysql: Re: Mysql and FOREIGN KEY

List:	General Discussion	« Previous Message Next Message »
From:	Nils Meyer	Date:	February 21 2007 4:05pm
Subject:	Re: Mysql and FOREIGN KEY
View as plain text

Hi,

Micol lupen wrote:
> FOREIGN
> KEY(of_idvillaggio),REFERENCES villaggio(idvillaggio)
                     ^^^ check here!
> ON UPDATE CASCADE ON DELETE RESTRICT)ENGINE=INNODB;

No comma before REFERENCES. REFERENCES is part of the foreign key 
definition.

regards
Nils

Thread
• Mysql and FOREIGN KEY	Micol lupen	21 Feb
• Re: Mysql and FOREIGN KEY	Gerald L. Clark	21 Feb
• Re: Mysql and FOREIGN KEY	Nils Meyer	21 Feb