Skip navigation links
C.5.27 Changements de la version 3.22.9 »
Section Navigation      [Toggle]

C.5.26. Changements de la version 3.22.10

  • 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 ).

  • 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.