Functionality added or changed:
NULL is now sorted
LAST if you use
ORDER BY ... DESC (as it was before MySQL
4.0.2). This change was required to comply with the SQL-99
standard. (The original change was made because we thought
that SQL-99 required
NULL to be always
sorted at the same position, but this was incorrect).
START TRANSACTION (SQL-99 syntax)
as alias for
BEGIN. This is recommended
to use instead of
BEGIN to start a
OLD_PASSWORD() as a synonym for
ALL in group functions.
Added support for some new
INNER JOIN and
JOIN syntaxes. For example,
SELECT * FROM t1 INNER JOIN t2 didn't
Novell NetWare 6.0 porting effort completed, Novell patches merged into the main source tree.
Fixed problem with multiple-table delete and
Fixed a problem with
BLOB NOT NULL
columns used with
Re-added missing pre- and post(un)install scripts to the Linux RPM packages (they were missing after the renaming of the server subpackage).
Fixed that table locks are not released with multiple-table
updates and deletes with
Fixed bug in updating
BLOB columns with
Fixed integer-wraparound when giving big integer (>= 10
digits) to function that requires an unsigned argument, like
CREATE TABLE (...) AUTO_INCREMENT=#.
MIN(key_column) could in some cases
NULL on a column with
NULL and other values.
MAX(key_column) could in some cases
return incorrect values when used in
MAX(key_column) could return incorrect
values if one of the tables was empty.
Fixed rare crash in compressed MyISAM tables with blobs.
Fixed bug in using aggregate functions as argument for
When running with
(default on Windows) and you had tables or databases with
mixed case on disk, then executing
STATUS followed with
DROP TABLE could
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.