--xml option to
mysql for producing XML output.
Added full-text variables
Added documentation for
embedded MySQL server library. Also added example programs
mysql client and
mysqltest test program) which use
Removed all Gemini hooks from MySQL server.
mysql_com.h, and added
Support for communication packets > 16M. In 4.0.1 we will
MyISAM to be able to handle these.
Secure connections (with SSL).
BIGINT constants now work.
handle signed and unsigned
New character set
provides correct German sorting.
STRCMP() now uses the current character
set when doing comparisons, which means that the default
comparison behavior now is case-insensitive.
TRUNCATE TABLE and
tbl_name are now separate functions. One bonus is
DELETE FROM tbl_name now returns the
number of deleted rows, rather than zero.
DROP DATABASE now executes a
DROP TABLE on all tables in the database,
which fixes a problem with
Added support for
Added support for multiple-table
HANDLER interface to
Added support for
MERGE tables. Patch from Benjamin
WEEK(date,0) to match the
calendar in the USA.
COUNT(DISTINCT) is about 30% faster.
Speed up all internal list handling.
ISNULL() and some other internal
Full-text index creation now is much faster.
Tree-like cache to speed up bulk inserts and
Searching on packed
VARCHAR) keys is
now much faster.
Optimized queries of type:
SELECT DISTINCT * from
tbl_name ORDER by key_part1 LIMIT row_count.
SHOW CREATE TABLE now shows all table
ORDER BY ... DESC can now use keys.
LOAD DATA FROM MASTER ``automatically''
sets up a slave.
mysqld_safe to make this name more in
line with other MySQL scripts/commands.
Added support for symbolic links to
MyISAM tables. Symlink handling is now
enabled by default for Windows.
FOUND_ROWS(). This makes it possible to
know how many rows a query would have returned without a
Changed output format of
SELECT expression LIMIT ....
ORDER BY syntax to
SHOW INDEXES is now a synonym for
ALTER TABLE tbl_name DISABLE KEYS
ALTER TABLE tbl_name ENABLE KEYS
Allow use of
IN as a synonym for
Implemented ``repair by sort'' for
ALTER TABLE, and
OPTIMIZE TABLE for tables with
FULLTEXT indexes are now up to 100 times
Allow SQL-99 syntax
Cleaned up global lock handling for
WITH READ LOCK.
Fixed problem with
DATETIME = constant in
--no-autocommit options to
mysqldump. (Thanks to Brian Aker for
distribution. (Thanks to mobile.de).
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.