Re: Foreign Key Problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, 2007-11-01 at 09:05 -0700, Kulluji wrote:
> Hi Everybody,
> 
> I am working in WAMP server for a small project. I am useing mysqlAdmin to
> create my tables. In this version of Mysql I am unable to set foreign key
> constraint. How do we do that? 
> 
> Thanks.
> 
> Francis David Kullu
> -- 
> View this message in context: http://www.nabble.com/Foreign-Key-Problem-tf4732309.html#a13531727
> Sent from the PHP - General mailing list archive at Nabble.com.

Make sure you are using a MySQL storage engine that supports referential
integrity.  MyISAM does not, but Innodb does.  If you execute SQL to add
a foreign key to a MyISAM table you will not get an error, but it will
also not add the key (only an index).

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux