mysql_install_db no longer starts the
MySQL server! You should start mysqld
with safe_mysqld after installing it! The
MySQL RPM will, however, start the server as before.
Added --bootstrap option to
mysqld and recoded
mysql_install_db to use it. This will
make it easier to install MySQL with RPMs.
Changed +, - (sign and
minus), *, /,
%, ABS() and
MOD() to be BIGINT
aware (64-bit safe).
Fixed a bug in ALTER TABLE that caused
mysqld to crash.
MySQL now always reports the conflicting key values when a
duplicate key entry occurs. (Before this was only reported
for INSERT.)
New syntax: INSERT INTO tbl_name SET
col_name=value, col_name=value, ...
Most errors in the .err log are now
prefixed with a time stamp.
Added option MYSQL_INIT_COMMAND to
mysql_options() to make a query on
connect or reconnect.
Added option MYSQL_READ_DEFAULT_FILE and
MYSQL_READ_DEFAULT_GROUP to
mysql_options() to read the following
parameters from the MySQL option files:
port, socket,
compress, password,
pipe, timeout,
user, init-command,
host and database.
Added maybe_null to the UDF structure.
Added option IGNORE to
INSERT statements with many rows.
Fixed some problems with sorting of the
koi8 character sets; users of
koi8
must run isamchk
-rq on each table that has an index on a
CHAR or VARCHAR
column.
New script mysql_setpermission, by Luuk
de Boer. It allows easy creation of new users with
permissions for specific databases.
Allow use of hexadecimal strings (0x...) when specifying a
constant string (like in the column separators with
LOAD DATA INFILE).
Ported to OS/2 (thanks to Antony T. Curtis
<antony.curtis@olcs.net>).
Added more variables to SHOW STATUS and
changed format of output to be like SHOW
VARIABLES.
Added extended-status command to
mysqladmin which will show the new status
variables.
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.
