Re: Foreign Key Constraints

[Martijn Tonies]

Hi,

> > Why not? What's wrong with this:
> >
> > BORROWER
> > BorrowerID
> >
> > BOOKS
> > BookID
> > BorrowerID (nullable)
> >
> > FK from Books.BorrowerID to Borrower.BorrowerID
> >
> > I haven't checked, but this _should_ be possible.
> >
> > With regards,
>
> Its a foreign key, you can not null foreign keys.. Thats the problem.

If this really is the case with MySQL, then this is the only database
engine that I know that doesn't allow this.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com