Foreign Key Con Phpmyadmin

[marxwell]

Mi sa di no. Ho corretto e ho inserito:

CREATE TABLE `foto` (
`id` SMALLINT( 6 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`categoria` VARCHAR( 255 ) NOT NULL ,
`titolo` VARCHAR( 255 ) NOT NULL ,
`source` VARCHAR( 255 ) NOT NULL ,
KEY `foto` ( `categoria` ) ,
FOREIGN KEY `categoria` REFERENCES `categoria foto` ( `categoria` ) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = innodb; 

Risultato:


#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'REFERENCES `categoria foto` ( `categoria` ) ON DELETE CASCADE ON UPDATE CASCADE
' at line 7