17 messages in com.mysql.lists.mysqlRe: Foreign Key Constraints
FromSent OnAttachments
kyu...@spymac.com26 May 2004 21:22 
Jeff Smelser26 May 2004 21:32 
Colin Bull27 May 2004 00:42 
Robert J Taylor27 May 2004 00:56 
Martijn Tonies27 May 2004 00:59 
SGr...@unimin.com27 May 2004 06:23 
Jeff Smelser27 May 2004 07:23 
Martijn Tonies27 May 2004 07:55 
Martijn Tonies28 May 2004 00:57 
Jeff Smelser28 May 2004 08:01 
Martijn Tonies28 May 2004 08:42 
Michael Stassen28 May 2004 09:25 
Michael Stassen28 May 2004 09:44 
Martijn Tonies28 May 2004 09:49 
Jeff Smelser28 May 2004 09:55 
Jeff Smelser28 May 2004 09:58 
Martijn Tonies28 May 2004 10:29 
Subject:Re: Foreign Key Constraints
From:Jeff Smelser (trad@smelser.org)
Date:05/27/2004 07:23:57 AM
List:com.mysql.lists.mysql

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1

On Thursday 27 May 2004 03:00 am, Martijn Tonies wrote:

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.

- -- Practice safe sin. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQFAtfoTld4MRA3gEwYRApVcAJ9RNWF9qZrresicBlct3TP2fpEL1wCg3xIx VER2P5MGzLgUqLRc7JZLFys= =qVNw -----END PGP SIGNATURE-----