What are you reading? MySQL supports the ANSI SQL92 standard almost in its entirety … something that other larger (read: more expensive) systems don't even claim to do … (this is from memory so don't flame me if I'm a little off).
Apparently, methinks that you've been brainwashed by unix a bit. Let me take a random guess: you've been using unix for quite a while, haven't you?
MySQL, along with unix, c, shell, perl, php, apache, cvs … are the unspeakably hideous “thing” that claims itself being a good technology whereas in fact they are the most condensed piss possible.
The debate of MySQL runs in every unix discussion group, and basically there is no way to convince those who has already been brain-washed by unix the hideousness of MySQL. For those serious, please read:
Perhaps MySQL is a dorky database that can be rather suitable for those who don't need real database features but rather just want to store small time data piecemeal instead of using files. But No! My position on MySQL is that it is a crime. Those who abide by it are criminals of the computing society. These are the people who harbor the thought that it is all right for software to crash or malfunction, that software is too complex and is all right to have bugs. These are the people why today's software are hated by their users.
The author of MySQL, Monty Widenius, along with Larry Wall,
Linus Torvald and friends, are assholes of inordinate measure. On the surface, they are these happy-go-lucky jovial and kind types who contribute to society, whereas in fact they are sloven _liars_ who peddle their _brainless hack_ and self esteem to get themselves ahead, ruthless about the harm they do to the computing community. These are the crackpots in the computing world. Ask me and i'll show you my past essays on this matter.
[Disclaimer: All mention of real persons are opinion only.]
Here are some articles by other people on MySQL: