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.