FK wont work!

[xxreenaxx1]

I tired to create table that has a foreign key but it wont let me create it

CREATE TABLE IF NOT EXISTS `user` (
  `Use_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Use_Name` varchar(20) NOT NULL,
  `Use_Password` varchar(20) NOT NULL,
  `Rol_ID` int(11) NOT NULL,
  PRIMARY KEY (`Use_ID`),
  KEY `Rol_ID` (`Rol_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

 

KEY 'Rol_ID'('Rol_ID') this is the foreign key. But I am not sure why its saying KEY. And when I view the design no tables are linked together.

[nankoweap]

i don't believe foreign keys are supported in the myisam engine. you may want to consider using innodb instead.

[xxreenaxx1]

I tired to view design and connected it that way

 

Thanks though...