View Full Version : How to create foreign key under xampp with MYISAM engine?

09-27-2007, 07:51 AM
Hi..guys! How can I create foreign key in table which using MYISAM storage engine in xampp?

09-27-2007, 08:29 AM
I don't think MYISAM types of table support foreign keys in MySQL you need to use InnoDB type of tables for that in which there is a FOREIGN KEY constraint available using which this can be achieved. Refer the following links for more details. The first link has the explanation with some examples of creating foreign keys and the second one is an article about this.


09-27-2007, 08:44 AM
Thanks..If I change all of my table from MYISAM to InnoDB in sql file and import it again,would it affect data integrity?