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.
SELECT INTO list_of_vars, which can
be of mixed, that is, global and local type. See
Section 18.104.22.168, « 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
User variable names are now case insensitive: if you do
SET @a=10; then
@A; will now return
sensitivity of a variable's value depends on the collation of
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.