LIMIT clause for the
You can now use the
/*! ... */ syntax to
hide MySQL-specific keywords when you write portable code.
MySQL will parse the code inside the comments as if the
comment characters didn't exist.
OPTIMIZE TABLE tbl_name can now be used
to reclaim disk space after many deletes. Currently, this
ALTER TABLE to regenerate the table,
but in the future it will use an integrated
isamchk for more speed.
libtool to get the configure
DELETE operations when using
Changed optimizer to make it better at deciding when to do a full join and when using keys.
You can now use
mysqladmin proc to
display information about your own threads. Only users with
PROCESS privilege can get information
about all threads. (In 4.0.2 one needs the
SUPER privilege for this.)
Added handling of formats
for numbers when using
TIMESTAMP types. (Formerly these formats
only worked with strings.)
Added connect option
to allow use of spaces after function names and before
(’ (Powerbuilder requires
this). This will make all function names reserved words.
--log-long-format option to
mysqld to enable timestamps and
INSERT_IDs in the update log.
--where option to
mysqldump (patch by Jim Faucette).
The lexical analyzer now uses ``perfect hashing'' for faster parsing of SQL statements.
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.