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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]