List:General Discussion« Previous MessageNext Message »
From:Vivek Khera Date:October 6 1999 6:58pm
Subject:Re: Normalization w/ MySQL?
View as plain text  
>>>>> "SF" == Steve Freitas <sflist@stripped> writes:

SF> Someone please correct me on this if I'm wrong.
SF> The way I understand MySQL is that foreign keys don't work. What this 
SF> means is that MySQL is incompatible with any database schema that's in 
SF> normalized form. Is this true?

Not incompatible, but you just have to do the work yourself.  Like
your example says, if the user modifies the field used to relate the
two tables, you better update that field on all other tables as well.
The DB won't do it for you or prevent it from happening.  Your
application is responsible for doing it.

Personally, I can't wait to have the referential integrity.  It might
even make joins faster, but then what do I know about optimization?
;-)

-- 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera@stripped       Rockville, MD       +1-301-545-6996
PGP & MIME spoken here            http://www.kciLink.com/home/khera/
Thread
Normalization w/ MySQL?Steve Freitas6 Oct
Re: Normalization w/ MySQL?Thimble Smith6 Oct
Re: Normalization w/ MySQL?Steve Freitas6 Oct
Re: Normalization w/ MySQL?Dan Nelson6 Oct
  • Re: Normalization w/ MySQL?James Manning6 Oct
    • Re: Normalization w/ MySQL?Dan Nelson6 Oct
Re: Normalization w/ MySQL?Steve Freitas6 Oct
Re: Normalization w/ MySQL?Vivek Khera6 Oct
Re: Normalization w/ MySQL?Bob Kline7 Oct