You can now use
BLOB columns and the
IS NULL and
NULL in the
All communication packets and row buffers are now allocated
dynamically on demand. The default value of
max_allowed_packet is now 64K for the
server and 512K for the client. This is mainly used to catch
incorrect packets that could trash all memory. The server
limit may be changed when it is started.
Changed stack usage to use less memory.
safe_mysqld to check for running
ELT() function is renamed to
FIELD(). The new
function returns a value based on an index:
FIELD() is the inverse of
field could have a
NULL value, now works.
A couple of bugs fixed in
SELECT ... GROUP
Fixed memory overrun bug in
many unoptimizable brace levels.
Fixed some small bugs in the grant code.
If hostname isn't found by
only the IP is checked. Previously, you got
Inserts of timestamps with values didn't always work.
INSERT INTO ... SELECT ... WHERE could
give the error
Added some tests to
safe_mysqld to make
LIKE was case-sensitive in some places
and case-insensitive in others. Now
is always case-insensitive.
anywhere on the line.
SET SQL_SELECT_LIMIT=#. See
the FAQ for more details.
New version of the
WEEKDAY() to also take a full
as argument. Before they only took a number of type
Added new function
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.