End of Product Lifecycle. Active development and support for MySQL Database Server versions 3.23, 4.0, and 4.1 has ended. For details, see http://www.mysql.com/about/legal/lifecycle/#calendar. Please consider upgrading to a recent version. Further updates to the content of this manual will be minimal. All formats of this manual will continue to be available until 31 Dec 2010.
Added mysqlbinlog program for displaying binary log files in text format.
mysql_real_escape_string() function to the MySQL C API.
Fixed a bug in
CONCAT() where one of the arguments was a function that returned a modified argument.
Fixed a critical bug in myisamchk, where it updated the header in the index file when one only checked the table. This confused the mysqld daemon if it updated the same table at the same time. Now the status in the index file is only updated if one uses
--update-state. With older myisamchk versions you should use
--read-only when only checking tables, if there is the slightest chance that the mysqld server is working on the table at the same time!
DROP TABLE is logged in the update log.
Fixed problem when searching on
DECIMAL() key field where the column data contained leading zeros.
Fix bug in myisamchk when the
AUTO_INCREMENT column isn't the first key.
DATETIME in ISO8601 format: 2000-03-12T12:00:00
Dynamic character sets. A mysqld binary can now handle many different character sets (you can choose which when starting mysqld).
REPAIR TABLE statement.
mysql_thread_safe() function to the MySQL C API.
UMASK_DIR environment variable.
CONNECTION_ID() function to return the client connection thread ID.
VARCHAR BINARY keys, where only a part of the column was indexed, the whole column of the result row wasn't compared.
sjis character set and
When running in ANSI mode, don't allow columns to be used that aren't in the
GROUP BY part.