开发者

foreign key problem in mysql

开发者 https://www.devze.com 2023-02-05 21:31 出处:网络
hay i have two tables i want to relate them with a foreign key i made it locally and works fine using innoDB but when i upload it to my server database the type of table automatically change to myISAM

hay i have two tables i want to relate them with a foreign key i made it locally and works fine using innoDB but when i upload it to my server database the type of table automatically change to myISAM. when i checked the type a开发者_如何转开发gain i found that there is no innoDB engine type instead MyISAM, MEMORY, BLACKHOLE, EXAMPLE, ARCHIVE, CSV,FEDERATED, MRG_MYISAM were there. please help which storage engine out of these can support foreign key.


None of them. Only innodb supports FKs.

0

精彩评论

暂无评论...
验证码 换一张
取 消