Added system
command to
mysql
.
Fixed bug when HANDLER
was used with some
unsupported table type.
mysqldump
now puts ALTER TABLE
tbl_name DISABLE KEYS
and ALTER TABLE
tbl_name ENABLE KEYS
in the sql dump.
Added mysql_fix_extensions
script.
Fixed stack overrun problem with LOAD DATA FROM
MASTER
on OSF/1.
Fixed shutdown problem on HP-UX.
Added DES_ENCRYPT()
and
DES_DECRYPT()
functions.
Added FLUSH DES_KEY_FILE
statement.
Added --des-key-file
option to
mysqld
.
HEX(string)
now returns the characters in
string
converted to hexadecimal.
Fixed problem with GRANT
when using
lower_case_table_names=1
.
Changed SELECT ... IN SHARE MODE
to
SELECT ... LOCK IN SHARE MODE
(as in
MySQL 3.23).
A new query cache to cache results from identical
SELECT
queries.
Fixed core dump bug on 64-bit machines when it got an incorrect communication packet.
MATCH ... AGAINST(... IN BOOLEAN MODE)
can now work without FULLTEXT
index.
Fixed slave to replicate from 3.23 master.
Miscellaneous replication fixes/cleanup.
Got shutdown to work on Mac OS X.
Added myisam/ft_dump
utility for
low-level inspection of FULLTEXT
indexes.
Fixed bug in DELETE ... WHERE ... MATCH
...
.
Added support for MATCH ... AGAINST(... IN BOOLEAN
MODE)
. Note: you
must rebuild your tables with ALTER TABLE tablename
TYPE=MyISAM
to be able to use boolean full-text
search.
LOCATE()
and INSTR()
are now case-sensitive if either argument is a binary
string.
Changed RAND()
initialization so that
RAND(N)
and RAND(N+1)
are more distinct.
Fixed core dump bug in UPDATE ... ORDER
BY
.
In 3.23, INSERT INTO ... SELECT
always
had IGNORE
enabled. Now MySQL will stop
(and possibly roll back) by default in case of an error
unless you specify IGNORE
.
Ignore DATA DIRECTORY
and INDEX
DIRECTORY
directives on Windows.
Added boolean full-text search code. It should be considered early alpha.
Extended MODIFY
and
CHANGE
in ALTER TABLE
to accept the FIRST
and
AFTER
keywords.
Indexes are now used with ORDER BY
on a
whole InnoDB
table.
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.