Re: does myisam force referrential integrity post version 5.0

[Sarah Sproehnle]

Seth Grimes wrote:
> Rajdeep Khurana wrote:
> > Hi,
> >
> > I beleive Foreign key concept has been around
> in
> > MyISAM since version 4.1 , but it didn't
> force
> > referential integrity.
> >
> > Does MyISAM enforce referential integrity
> from
> > version 5.0 .
> >
> > Thanks
>
> It's InnoDB that has supported foreign keys for a
> long time. MyISAM doesn't have them yet.
>
> Seth

For compatibility reasons (especially when using replication from InnoDB tables to MyISAM tables), MyISAM supports the *syntax* of foreign keys, however does not enforce referential integrity. As Jay mentioned, it's in the works!

Sarah Sproehnle
MySQL AB
www.mysql.com