sql - Why my table doesnt support FOREIGN KEYS?

Question

I have made a database and 10 tables in mysql(table type NONE) and i can't create foreign keys. An alert message says

SQLyog The selected table does not support foreign keys. Table engine must be InnoDB, PBXT or SolidDB

Will i must alter all of my tables now? thanks for any hint or suggestion

Answer 1

Typically, InnoDB is used to support foreign keys, and transactions:

http://dev.mysql.com/doc/refman/5.1/en/innodb.html

You can change the table engine on the fly:

ALTER TABLE tableName ENGINE = InnoDB;

You can also change the default -- for newly created tables -- as shown here:

http://dev.mysql.com/doc/refman/5.1/en/storage-engine-setting.html