Released on 16 Feb 2000
MySQL 3.23.11 Changelog

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 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 HIGH_PRIORITY option to INSERT. This overrides the effect of the --low-priority-updates server option and does not perform concurrent inserts.

  • Permit the ALTER TABLE tbl_name ADD (field_list) syntax.

  • Fixed problem with optimizer that could sometimes use incorrect keys.


  • Removed extra ) from the output of SHOW GRANTS.

  • Fixed problem when storing numbers in timestamps.

  • Fix problem with time zones that have half hour offsets.

  • Permit the syntax UNIQUE INDEX in CREATE statements.

  • mysqlhotcopy - fast online hot-backup utility for local MySQL databases. By Tim Bunce.

  • New more secure mysqlaccess. Thanks to Steve Harvey for this.

  • Added --i-am-a-dummy and --safe-updates options to mysql.

  • Added select_limit and max_join_size variables to mysql.

  • Added sql_max_join_size and sql_safe_updates options.

  • Added READ LOCAL lock that doesn't lock the table for concurrent inserts. (This is used by mysqldump.)

  • Changed that LOCK TABLES ... READ no longer permits concurrent inserts.

  • Added --skip-delay-key-write option to mysqld.

  • Fixed security problem in the protocol regarding password checking.

  • _rowid can now be used as an alias for an integer type unique indexed column.

  • Added back blocking of SIGPIPE when compiling with --thread-safe-clients to make things safe for old clients.