Difference between revisions of "Foreign Keys"

From Hostek.com Wiki
Jump to: navigation, search
(Created page with "==Are Foreign Keys Supported?== Yes. However they can only be created for InnoDB tables (not MyISAM tables, which are the default type). If you are creating your tables with ...")
(No difference)

Revision as of 10:19, 21 November 2012

Are Foreign Keys Supported?

Yes. However they can only be created for InnoDB tables (not MyISAM tables, which are the default type).

If you are creating your tables with SQL queries, you would just have to add "TYPE=INNODB" at the end of the table declaration.

If you are using phpMyAdmin, you would just select InnoDB as the type when you create your tables.