[+/-]
The following changelog shows what has already been done in the 5.0 tree:
Basic support for stored procedures (SQL:2003 style). See Chapitre 19, Procédures stockées et fonctions.
Added SELECT INTO list_of_vars
, which can
be of mixed, that is, global and local type. See
Section 19.2.9.3, « Syntaxe de SELECT ... INTO
».
Removed the update log. It is fully replaced by the binary
log. If the MySQL server is started with
--log-update
, it will be translated to
--log-bin
(or ignored if the server is
explicitly started with --log-bin
), and a
warning message will be written to the error log. Setting
SQL_LOG_UPDATE
will silently set
SQL_LOG_BIN
instead (or do nothing if the
server is explicitly started with --log-bin
).
User variable names are now case insensitive: if you do
SET @a=10;
then SELECT
@A;
will now return 10
. Case
sensitivity of a variable's value depends on the collation of
the value.
For a full list of changes, please refer to the changelog sections for each individual 5.0.x release.
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.