Does anyone else feel that lack of support for subqueries is the number 1
deficiency in MySQL? I'm not sure why support for subqueries is being
deferred for so long. Certainly, uncorrelated subqueries are almost trivial
to implement and the truth is that correlated subqueries aren't really all
How are people representing subsecond date/time values with MySQL?
In Sybase, the datetime data type supports subsecond values with a
resolution of 1/300th of a second (go figure). PostgreSQL does microseconds
with its time (4 bytes) and timestamp (8 bytes) data types.
More generally, JDBC