A new storage engine library (
with a lot of new features. See 項7.1. 「
You can create in-memory
which are extremely fast for lookups.
Support for big files (63-bit) on OSs that support big files.
LOAD_FILE(filename) to get
the contents of a file as a string value.
<=> which will act as
= but will return TRUE if both arguments
NULL. This is useful for comparing
changes between tables.
Added the ODBC 3.0
Columns defined as
FLOAT(X) are not
rounded on storage and may be in scientific notation (1.0
E+10) when retrieved.
REPLACE is now faster than before.
LIKE character comparison to
=; This means that
LIKE 'e' is now true. (If the line doesn't display
correctly, the latter 'e' is a French 'e' with a dot above.)
SHOW TABLE STATUS returns a lot of
information about the tables.
LIKE to the
Privileges column to
Comment columns to
Added comments to tables (with
CREATE TABLE ...
UNIQUE, as in
table_name (col INT not null UNIQUE)
New create syntax:
CREATE TABLE table_name SELECT
New create syntax:
CREATE TABLE IF NOT EXISTS
Allow creation of
DATE_FORMAT() now requires
%’ before any format
DELAYED is now a reserved word (sorry
about that :( ).
An example procedure is added:
sql_analyse.c. This will describe
the data in your query. Try the following:
SELECT ... FROM ... WHERE ... PROCEDURE ANALYSE([max elements,[max memory]])
This procedure is extremely useful when you want to check the data in your table!
BINARY cast to force a string to be
compared in case-sensitive fashion.
--skip-show-database option to
Check whether a row has changed in an
UPDATE now also works with
INNER join syntax.
NOTE: This made
INNER a reserved word!
Added support for netmasks to the hostname in the MySQL
grant tables. You can specify a netmask using the
If you compare a
NOT NULL DATE/DATETIME
IS NULL, this is changed to a
0 to satisfy some ODBC
NULL IN (...) now returns
NULL instead of
This will ensure that
null_column NOT IN
(...) doesn't match
Fix storage of floating-point values in
Changed parsing of
TIME strings to be
more strict. Now the fractional second part is detected (and
currently skipped). The following formats are supported:
Detect (and ignore) fractional second part from
LOW_PRIORITY attribute to
LOAD DATA INFILE.
The default index name now uses the same case as the column name on which the index name is based.
Changed default number of connections to 100.
Use bigger buffers when using
DECIMAL(x,y) now works according to
Added aggregate UDF functions. Thanks to Andreas F. Bobak
<firstname.lastname@example.org>) for this!
LAST_INSERT_ID() is now updated for
INSERT INTO ... SELECT.
Some small changes to the join table optimizer to make some joins faster.
SELECT DISTINCT is much faster; it uses
UNIQUE functionality in
MyISAM. One difference compared to MySQL
Version 3.22 is that the output of
DISTINCT is no longer sorted.
All C client API macros are now functions to make shared
libraries more reliable. Because of this, you can no longer
mysql_num_fields() on a
MYSQL object, you must use
Added use of
LIBWRAP; patch by Henning P.
AUTO_INCREMENT for other than
AUTO_INCREMENT will now
automatically make the column
NULL as the default value for
SQL_SMALL_RESULT is now default.
Added a shared library RPM. This enhancement was contributed
by David Fox (
--disable-large-files switches to
configure.in for some systems where
this is automatically turned off because of broken
readline to 4.0.
CREATE TABLE options:
--default-table-type option to
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.