Someone please correct me on this if I'm wrong.
The way I understand MySQL is that foreign keys don't work. What this
means is that MySQL is incompatible with any database schema that's in
normalized form. Is this true?
And if this is true, what does everybody do? If I want to, say, add
something to the shopping cart table for someone, I'd have to insert
their account number along with everything else. And if they changed
their account number over in their account management screen (unlikely
but go with me), unless my program went through and modified the stored
account number in the shopping cart table, it'd be lost to them, wouldn't
it?
Thanks,
Steve Freitas
Newport Beach, California
