According to the default settings, you can not create a foreign key in mysql5.0. Because it requires you to change the type of table to "innoDB". Otherwise you will get this error:
the innoDB feature is disable...
In the Documentation of mysql, it comments that in mysql4.2,5.0 etc you must enable "innoDB" when creating FK. Just modify my.ini in C:\WINDOWS, find this line "skip-innodb" and change it to "#skip-innodb".
posted on 2008-03-08 10:00
Carl 閱讀(170)
評論(0) 編輯 收藏 所屬分類:
Mysql