mysql添加外键自动消失_mysql – phpMyAdmin中消失的外键

我在

mysql中创建一个新表,我正在尝试向其中一个字段添加外键约束.

CREATE TABLE `onlineorder` (

`receiptid` varchar(10) NOT NULL default '',

`delivereddate` date default NULL,

`cid` int(10) NOT NULL,

`card#` int(10) default NULL,

`expire` date default NULL,

PRIMARY KEY (`receiptid`),

FOREIGN KEY (receiptid) REFERENCES purchase

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

但是,在创建它之后,我进入phpMyAdmin并导出表.似乎外键约束已经消失.

CREATE TABLE `onlineorder` (

`receiptid` varchar(10) NOT NULL default '',

`delivereddate` date default NULL,

`cid` int(10) NOT NULL,

`card#` int(10) default NULL,

`expire` date default NULL,

PRIMARY KEY (`receiptid`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

phpMyAdmin是摆脱外键还是我在这里做错了什么？