[RESOLVED] How to create foreign key under xampp with MYISAM engine?

[devil_vin]

Hi..guys! How can I create foreign key in table which using MYISAM storage engine in xampp?

[NogDog]

See http://dev.mysql.com/doc/refman/5.0/en/innodb-foreign-key-constraints.html for info on foreign keys. The most immediate issue is that both tables must be InnoDB engine-type tables. MyISAM tables will successfully parse any foreign key assignments, then blissfully ignore them.

[devil_vin]

Thanks..If I change all of my table from MYISAM to InnoDB in sql file and import it again,would it affect data integrity?

[devil_vin]

Thanks..If I change all of my table from MYISAM to InnoDB in sql file and import it again,would it affect data integrity?

[NogDog]

It should not affect the data, but of course you should do a back-up of the database before doing any table alterations, because if you don't, that's when we'll find out I'm wrong. 😉