-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Wednesday 26 May 2004 11:22 pm, [EMAIL PROTECTED] wrote:
> Hi, I am trying to use the foreign key constraints from InnoDB
> and creating indexes is a requirement for foreign key.
> The problem is that by creating index for my foreign key,
> it does not allow my foreign key to have null or blank values which my
> records will have. For eg. a BorrowerID is a foreign key on a Book table,
> but when the book is not borrowed, the BorrowerID will be null and I can't
> seem to import the data containing null values for the foreign key. Is
> there a way to solve this?
> Thanks.
I am not to sure how its possible to fix it.. Thinking about this.. I would
have a bookid which is never null. Considering no matter if the book is out
or not, you have that book. I then would have a borrow table, lets say, as
the foreign key would be bookid.. I date borrowed, and date returned would be
how I would know if its out or not..
Just thinking off the top of my head as there probably is a better way to do
it.
I am sure there are other ways to do this.. Foreign keys can't be null.
Jeff
- --
Calm down--It's only ones and zeroes.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)
iD8DBQFAtW9lld4MRA3gEwYRAkaAAKCtA0+GlFLRifkWDdH661LIF7gaVwCdHM8V
zxbQk96yn0v3dTTBD9F4gWM=
=JLfz
-----END PGP SIGNATURE-----
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
