- Documentation Library
- Table of Contents
- MySQL 3.23/4.0/4.1 Manual
- Table of Contents
- D MySQL Change History
- D.1 Changes in release 5.0.0 (Development)
- D.2 Changes in release 4.1.x (Alpha)
- D.3 Changes in release 4.0.x (Production)
- D.4 Changes in release 3.23.x (Recent; still supported)
- D.5 Changes in release 3.22.x (Old; discontinued)
- D.6 Changes in release 3.21.x
- D.7 Changes in release 3.20.x
- D.8 Changes in release 3.19.x
[+/-]
Version 4.1 of the MySQL server includes many enhancements and new features. Binaries for this version are available for download at http://www.mysql.com/downloads/mysql-4.1.html.
Subqueries and derived tables (unnamed views). See 項6.4.2. 「サブクエリ構文」.
INSERT ... ON DUPLICATE KEY UPDATE ...syntax. This allows you toUPDATEan existing row if the insert would cause a duplicate value in aPRIMARYorUNIQUEkey. (REPLACEallows you to overwrite an existing row, which is something entirely different.) See 項6.4.3. 「INSERT構文」.A newly designed
GROUP_CONCAT()aggregate function. See 項6.3.7. 「GROUP BY節で使用する関数と修飾子」.Extensive Unicode (UTF8) support.
Character sets can be defined per column, table, and database.
New key cache for
MyISAMtables with many tunable parameters. You can have multiple key caches, preload index into caches for batches...BTREEindex onHEAPtables.Support for OpenGIS spatial types (geographical data). See 章 10. MySQL における空間情報の機能.
SHOW WARNINGSshows warnings for the last command. See 項4.6.8.9. 「SHOW WARNINGS | ERRORS」.Faster binary protocol with prepared statements and parameter binding. See 項11.1.4. 「C API のプリペアドステートメント」.
You can now issue multiple statements with a single C API call and then read the results in one go. See 項11.1.8. 「C API における複数クエリの実行の取り扱い」.
Create Table:
CREATE [TEMPORARY] TABLE [IF NOT EXISTS] table2 LIKE table1.Server based
HELPcommand that can be used in themysqlcommand line client (and other clients) to get help for SQL statements.
For a full list of changes, please refer to the changelog sections for each individual 4.1.x release.
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.
