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 to
existing row if the insert would cause a duplicate value in a
REPLACE allows you to overwrite an
existing row, which is something entirely different.) See
A newly designed
GROUP BY 節で使用する関数と修飾子」.
Extensive Unicode (UTF8) support.
Character sets can be defined per column, table, and database.
New key cache for
MyISAM tables with many
tunable parameters. You can have multiple key caches, preload
index into caches for batches...
BTREE index on
Support for OpenGIS spatial types (geographical data). See 章 10. MySQL における空間情報の機能.
SHOW WARNINGS shows warnings for the last
command. See 項188.8.131.52. 「
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 [TEMPORARY] TABLE [IF NOT
EXISTS] table2 LIKE table1.
HELP command that can be used
mysql command 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.