>>>>> "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/