Some new functions, some more optimization on joins.
Should now compile clean on Linux (2.0.x).
Added functions DATABASE()
,
USER()
, POW()
,
LOG10()
(needed for ODBC).
In a WHERE
with an ORDER
BY
on fields from only one table, the table is now
preferred as first table in a multi-join.
HAVING
and IS NULL
or
IS NOT NULL
now works.
A group on one column and a sort on a group function
(SUM()
, AVG()
...)
didn't work together. Fixed.
mysqldump
: Didn't send password to
server.
This is a translation of the MySQL Reference Manual that can be found at dev.mysql.com. The original Reference Manual is in English, and this translation is not necessarily as up to date as the English version.