The following symbols are now reserved words:
TIME
, DATE
,
TIMESTAMP
, TEXT
,
BIT
, ENUM
,
NO
, ACTION
,
CHECK
, YEAR
,
MONTH
, DAY
,
HOUR
, MINUTE
,
SECOND
, STATUS
,
VARIABLES
.
Setting a TIMESTAMP
to
NULL
in LOAD DATA INFILE
...
didn't set the current time for the
TIMESTAMP
.
Fix BETWEEN
to recognise binary strings.
Now BETWEEN
is case-sensitive.
Added --skip-thread-priority
option to
mysqld
, for systems where
mysqld
's thread scheduling doesn't work
properly (BSDI 3.1).
Added ODBC functions DAYNAME()
and
MONTHNAME()
.
Added function TIME_FORMAT()
. This works
like DATE_FORMAT()
, but takes a time
string ('HH:MM:SS'
) as argument.
Fixed unlikely(?) key optimiser bug when using
OR
operators of key parts inside
AND
expressions.
Added variables
command to
mysqladmin
.
A lot of small changes to the binary releases.
Fixed a bug in the new protocol from MySQL Version 3.21.20.
Changed ALTER TABLE
to work with Windows
(Windows can't rename open files). Also fixed a couple of
small bugs in the Windows version.
All standard MySQL clients are now ported to MySQL for Windows.
MySQL can now be started as a service on NT.
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.