|
|
Posted by Erwin Moller on 09/14/05 11:09
Steve wrote:
>
>> I was baffled to see that I can make Foreign Keys, but they are actually
>> never checked by the mySQL engine.
>
>> Am I mad, or does MySQL not support Foreign Keys?
>> And if so: Why is it that MySQL is so popular?
>
> Erwin:
>
> It depends what table type you are using. MySQL lets you specify
> foreign keys for compatibility, but ignores them unless you are using
> InnoDB tables.
>
> The main reasons for widespread MySQL adoption? It is fast and simple,
> it has (or had) better documentation and support, lots of 3rd party
> tools. For lightweight web apps where you don't need transactions it is
> a good choice.
>
> ---
> Steve
Thank you Steve. InnoDB-tables solves that problem.
Now I have to contact that provider to ask them to implement it, or just
learn my friend to program wisely so he doesn't need FK's.
:-)
Thanks.
Regards,
Erwin Moller
Navigation:
[Reply to this message]
|