Re: Foreign Key Problem
| From: | mlists | Date: | Thu, 01 Nov 2007 18:15:46 +0000 |
| Subject: | Re: Foreign Key Problem | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-263945@lists.php.net to get a copy of this message | ||
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).