At 11:38, 19991005, Steve Freitas wrote:
>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
Please see the hundreds of posts on this in the mailing list. Here's
one example others have found useful in the past: