Originally posted by Crashed_Again
Is MySQL a figment of my imagination? Its not "real"?
It may be faster than Postgres, but it STILL lacks
features that Postgres has supported for YEARS.
It supports less SQL 92 and 99 features than
From the MySQL features list
Expanded support for subqueries
Subqueries allow you to use the result of one query as a component of a larger query. The MySQL server already supports some forms of this technique, such as INSERT INTO ... SELECT ..., and this support will be expanded in version 4.1 to include nested SELECT queries, which is one of the most-requested features from our users.
/me chuckles ...
Then there's transaction safety, restore failed
table updates (after power-failure) from log...
Guess the speed must come from some source :)