Foreign Keys

From Hostek.com Wiki
Revision as of 10:19, 21 November 2012 by Carlb (Talk | contribs) (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 ...")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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.

Retrieved from "https://wiki.hostek.com/index.php?title=Foreign_Keys&oldid=735"