Added patches for MIT-pthreads on NetBSD.
Fixed range bug in MyISAM
.
ASC
is now the default again for
ORDER BY
.
Added LIMIT
to UPDATE
.
Added mysql_change_user()
function to the
MySQL C API.
Added character set to SHOW VARIABLES
.
Added support of --[whitespace]
comments.
Allow INSERT into tbl_name VALUES ()
,
that is, you may now specify an empty value list to insert a
row in which each column is set to its default value.
Changed SUBSTRING(text FROM pos)
to
conform to SQL-99. (Before this construct returned the
rightmost pos
characters.)
SUM()
with GROUP BY
returned 0 on some systems.
Changed output for SHOW TABLE STATUS
.
Added DELAY_KEY_WRITE
option to
CREATE TABLE
.
Allow AUTO_INCREMENT
on any key part.
Fixed problem with YEAR(NOW())
and
YEAR(CURDATE())
.
Added CASE
construct.
New function COALESCE()
.
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.