Entry

How do i set up foreign key constraints in MySQL?

Nov 22nd, 2008 12:57
haytham ali, dman, Michael Mak, Ryan Parr, Johnny Nguyen, http://msryat.org

MySQL does not support foreign key constraints, though the ability 
will 
be in version 4.0.
For the time being MySQL supports an extension called InnoDB which 
supports foreign keys and transactions. Check out the URL I referenced 
(<a 
href="http://www.mysql.com/doc/S/E/SEC433.html">http://www.mysql.com/do
c
/S/E/SEC433.html</a>) for more information.
To configure Foreign Key graphically, you could try to download 
PremiumSoft Navicat (http://www.navicat.com) or EMS MySQL tool 
(http://www.ems-hitech.com/mymanager). They both support to configure 
Foreign Keys visually.
http://6rb.com
http://fr7.com
http://dir.msryat.org
http://6ef.com
http://forums.msryat.org
http://www.arabcar.com
http://www.alshalah.com