Posted by Steve on 09/13/05 18:45

> 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

[Back to original message]