End of Product LifecycleActive development and support for MySQL Database Server versions 3.23, 4.0, and 4.1 has ended. For details, see http://www.mysql.com/about/legal/lifecycle/#calendar. Please consider upgrading to a recent version. Further updates to the content of this manual will be minimal. All formats of this manual will continue to be available until 31 Dec 2010.
Functionality Added or Changed
TIMESTAMP is now returned as a
string of type
'YYYY-MM-DD HH:MM:SS' and
different timestamp lengths are not supported.
This change was necessary for SQL standards compliance. In a future version, a further change will be made (backward compatible with this change), permitting the timestamp length to indicate the desired number of digits of fractions of a second.
Replication: Replication now
RAND() and user
On Windows, we are now using shared memory to communicate
between server and client when they are running on the same
machine and you are connecting to
BTREE index on
CRC32() function to compute
cyclic redundancy check value.
API client function.
Character sets to be defined per column, table and database.
SHOW FULL COLUMNS FROM
Permit empty index lists to be specified for
IGNORE INDEX, and
Server side help for all MySQL functions. One can now type
help week in the mysql
client and get help for the
SELECT ... FROM DUAL is an alias for
SELECT .... (To be compatible with some
other database systems).
determining the connection identifier of the client that holds
a given advisory lock.
SERIAL DEFAULT VALUE added as an alias for
One can add a comment per column in
One can create a table from the existing table using
CREATE [TEMPORARY] TABLE [IF NOT EXISTS]
. The table can be
either normal or temporary.
SELECT .. LIMIT 0 did not return the proper
row count for
DROP TEMPORARY TABLE now drops only
temporary tables and doesn't end transactions.
SELECT a.col1, b.col2 FROM (SELECT MAX(col1) AS col1 FROM root_table) a, other_table b WHERE a.col1=b.col1;
REPAIR TABLE of
MyISAM tables now uses less temporary disk
space when sorting char columns.
checking is now a bit stricter to support the ability to
automatically distinguish between date, datetime, and time
with microseconds. For example, dates of type
YYYYMMDD HHMMDD are no longer supported;
you must either have separators between each
part or not at all.
FALSE added as
alias for 1 and 0, respectively.
SELECT * from t1 where t1.a=(SELECT t2.b
New more secure client authentication based on 45-byte
passwords in the
mysql command-line client attempted
to interpret quotation marks within comments. (Bug #539)
CREATE TABLE the attribute
SERIAL is now an alias for
UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE.
old-password command to
mysqladmin for changing password but
storing it using the old password-hashing format.
CONVERT(... USING ...)
syntax for converting string values between character sets.
Multi-line queries: You can now issue several queries at once and then read the results in one go.
CREATE TABLE foo (a TINYINT NOT NULL) SELECT b+1 AS a FROM bar;
integer MOD integer and
integer DIV integer.
is now a reserved word.
SHOW [COUNT(*)] WARNINGS shows warnings
from the last command.
Added support for
CHAR BYTE is an alias for the
CHAR BINARY data type.
foo (a INT not null primary key) the
PRIMARY word is now optional.
function that returns the variance of
record_in_range() method to
MERGE tables to be able to choose the
correct index when there are many to choose from.
Support for GIS (Geometrical data). See Chapter 16, Spatial Extensions.
libmysqlclient did not always fetch column
default values correctly.
Aliases are now forced in derived tables, as per standard SQL.
New faster client/server protocol that supports prepared statements, bound parameters, and bound result columns, binary transfer of data, warnings.
One can specify many temporary directories to be used in a
round-robin fashion with:
Faster embedded server (new internal communication protocol).
mode to be changed on the fly.
Unicode (UTF8) support.
Added database and real table name (in case of alias) to the
in expressions; it produces the column's default value.
Permit index type to be specified explicitly for some storage
syntax in index