From: Date: January 10 2007 9:34am
Subject: svn commit - mysqldoc@docsrva: r4430 - trunk/refman-4.1
List-Archive: http://lists.mysql.com/commits/17832
Message-Id: <200701100834.l0A8Y9KA002643@docsrva.mysql.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
Author: jstephens
Date: 2007-01-10 09:34:07 +0100 (Wed, 10 Jan 2007)
New Revision: 4430
Log:
Merged 4-1-features section into mysql-4-1-nutshell (request from Bryan)
Modified:
trunk/refman-4.1/introduction.xml
trunk/refman-4.1/renamed-nodes.txt
Modified: trunk/refman-4.1/introduction.xml
===================================================================
--- trunk/refman-4.1/introduction.xml 2007-01-10 07:54:15 UTC (rev 4429)
+++ trunk/refman-4.1/introduction.xml 2007-01-10 08:34:07 UTC (rev 4430)
Changed blocks: 1, Lines Added: 232, Lines Deleted: 243; 19952 bytes
@@ -659,295 +659,284 @@
available. See .
-
+
+ The following features are implemented in MySQL 4.1. Features
+ that are available in MySQL 5.0 are described in
+ .
+
- Features Available in MySQL 4.1
+
-
- This section lists features implemented in MySQL 4.1. Features
- that are available in MySQL 5.0 are described in
- .
-
+
+
+ Support for subqueries and derived
+ tables:
+
-
+
-
-
- Support for subqueries and derived
- tables:
-
+
+
+ A subquery
is a SELECT
+ statement nested within another statement. A
+ derived table
(an unnamed view) is a
+ subquery in the FROM clause of
+ another statement. See .
+
+
-
+
+
-
-
- A subquery
is a
- SELECT statement nested within
- another statement. A derived table
(an
- unnamed view) is a subquery in the
- FROM clause of another statement.
- See .
-
-
+
+
+ Speed enhancements:
+
-
-
+
-
-
- Speed enhancements:
-
+
+
+ Faster binary client/server protocol with support for
+ prepared statements and parameter binding. See
+ .
+
+
-
+
+
+ BTREE indexing is supported for
+ HEAP tables, significantly improving
+ response time for non-exact searches.
+
+
-
-
- Faster binary client/server protocol with support for
- prepared statements and parameter binding. See
- .
-
-
+
+
-
-
- BTREE indexing is supported for
- HEAP tables, significantly
- improving response time for non-exact searches.
-
-
+
+
+ Added functionality:
+
-
-
+
-
-
- Added functionality:
-
+
+
+ CREATE TABLE
+ tbl_name2 LIKE
+ tbl_name1 allows
+ you to create, with a single statement, a new table with
+ a structure exactly like that of an existing table.
+
+
-
+
+
+ The MyISAM storage engine added
+ support for OpenGIS spatial types for storing
+ geographical data. See
+ .
+
+
-
-
- CREATE TABLE
- tbl_name2 LIKE
- tbl_name1 allows
- you to create, with a single statement, a new table
- with a structure exactly like that of an existing
- table.
-
-
+
+
+ Support was added for replication over SSL connections.
+
+
-
-
- The MyISAM storage engine added
- support for OpenGIS spatial types for storing
- geographical data. See
- .
-
-
+
+
+ Support for a number of additional storage engines was
+ implemented in the MySQL 4.1 release series:
+
-
-
- Support was added for replication over SSL
- connections.
-
-
+
-
-
- Support for a number of additional storage engines was
- implemented in the MySQL 4.1 release series:
-
+
+
+ The EXAMPLE storage engine is a
+ stub
engine that serves as an example
+ in the MySQL source code for writing new storage
+ engines, and is primarily of interest to developers.
+ See .
+
+
-
+
+
+ NDB Cluster is the storage engine
+ used by MySQL Cluster to implement tables that are
+ partitioned over many computers. See
+ .
+
+
-
-
- The EXAMPLE storage engine is a
- stub
engine that serves as an
- example in the MySQL source code for writing new
- storage engines, and is primarily of interest to
- developers. See
- .
-
-
+
+
+ The ARCHIVE storage engine is
+ used for storing large amounts of data without
+ indexes in a very small footprint. See
+ .
+
+
-
-
- NDB Cluster is the storage
- engine used by MySQL Cluster to implement tables
- that are partitioned over many computers. See
- .
-
-
+
+
+ The CSV storage engine stores
+ data in text files using comma-separated values
+ format. See .
+
+
-
-
- The ARCHIVE storage engine is
- used for storing large amounts of data without
- indexes in a very small footprint. See
- .
-
-
+
+
+ The BLACKHOLE storage engine
+ accepts but does not store data, and always returns
+ an empty result set. It is for use primarily in
+ replication. See
+ .
+
+
-
-
- The CSV storage engine stores
- data in text files using comma-separated values
- format. See .
-
-
+
-
-
- The BLACKHOLE storage engine
- accepts but does not store data, and always
- returns an empty result set. It is for use
- primarily in replication. See
- .
-
-
+
+ Note: These engine were
+ implemented at different points in the development of
+ MySQL 4.1. Please see the indicated sections for
+ particulars in each case.
+
+
-
+
+
-
- Note: These engine
- were implemented at different points in the
- development of MySQL 4.1. Please see the indicated
- sections for particulars in each case.
-
-
+
+
+ Standards compliance, portability, and
+ migration:
+
-
-
+
-
-
- Standards compliance, portability,
- and migration:
-
+
+
+ The enhanced client/server protocol available beginning
+ with MySQL 4.1.1 provides the ability to pass multiple
+ warnings to the client, rather than only a single
+ result, making it much easier to track problems that
+ occur in operations such as bulk data loading.
+
+
-
+
+
+ SHOW WARNINGS shows warnings for the
+ last command. See .
+
+
-
-
- The enhanced client/server protocol available
- beginning with MySQL 4.1.1 provides the ability to
- pass multiple warnings to the client, rather than only
- a single result, making it much easier to track
- problems that occur in operations such as bulk data
- loading.
-
-
+
+
-
-
- SHOW WARNINGS shows warnings for
- the last command. See .
-
-
+
+
+ Internationalization and
+ Localization:
+
-
-
+
-
-
- Internationalization and
- Localization:
-
+
+
+ To support applications that require the use of local
+ languages, the MySQL software added extensive Unicode
+ support through the utf8 and
+ ucs2 character sets.
+
+
-
+
+
+ Definition of character sets by column, table, and
+ database. This allows for a high degree of flexibility
+ in application design, particularly for multi-language
+ Web sites. See .
+
+
-
-
- To support applications that require the use of local
- languages, the MySQL software added extensive Unicode
- support through the utf8 and
- ucs2 character sets.
-
-
+
+
+ Per-connection time zones support, allowing individual
+ clients to select their own time zones when necessary.
+
+
-
-
- Definition of character sets by column, table, and
- database. This allows for a high degree of flexibility
- in application design, particularly for multi-language
- Web sites. See .
-
-
+
+
-
-
- Per-connection time zones support, allowing individual
- clients to select their own time zones when necessary.
-
-
+
+
+ Usability enhancements:
+
-
-
+
-
-
- Usability enhancements:
-
+
+
+ The addition of a server-based HELP
+ command that can be used to get help information for SQL
+ statements. This information is always applicable to the
+ particular server version being used. Because this
+ information is available by issuing an SQL statement,
+ any client can access it. For example, the
+ help command of the
+ mysql command-line client has been
+ modified to have this capability.
+
+
-
+
+
+ The improved client/server protocol allows multiple
+ statements to be issued with a single call, and for
+ returning multiple result sets. See
+ .
+
+
-
-
- The addition of a server-based HELP
- command that can be used to get help information for
- SQL statements. This information is always applicable
- to the particular server version being used. Because
- this information is available by issuing an SQL
- statement, any client can access it. For example, the
- help command of the
- mysql command-line client has been
- modified to have this capability.
-
-
+
+
+ The syntax INSERT ... ON DUPLICATE KEY UPDATE
+ ... was implemented. This allows you to update
+ an existing row if the insert would have caused a
+ duplicate value for a primary or unique index. See
+ .
+
+
-
-
- The improved client/server protocol allows multiple
- statements to be issued with a single call, and for
- returning multiple result sets. See
- .
-
-
+
+
+ The aggregate function
+ GROUP_CONCAT(), added the capability
+ to concatenate column values from grouped rows into a
+ single result string. See
+ .
+
+
-
-
- The syntax INSERT ... ON DUPLICATE KEY UPDATE
- ... was implemented. This allows you to
- update an existing row if the insert would have caused
- a duplicate value for a primary or unique index. See
- .
-
-
+
+
-
-
- The aggregate function
- GROUP_CONCAT(), added the
- capability to concatenate column values from grouped
- rows into a single result string. See
- .
-
-
+
-
-
+
+ The News section of this manual includes a more in-depth list of
+ MySQL 4.1 features. See .
+
-
-
-
- The News section of this manual includes a more in-depth list
- of MySQL 4.1 features. See .
-
-
-
-
Modified: trunk/refman-4.1/renamed-nodes.txt
===================================================================
--- trunk/refman-4.1/renamed-nodes.txt 2007-01-10 07:54:15 UTC (rev 4429)
+++ trunk/refman-4.1/renamed-nodes.txt 2007-01-10 08:34:07 UTC (rev 4430)
Changed blocks: 1, Lines Added: 1, Lines Deleted: 0; 482 bytes
@@ -297,5 +297,6 @@
system system-optimization
nutshell-4-0-features mysql-4-0-nutshell
nutshell-embedded-mysql mysql-4-0-nutshell
+nutshell-4-1-features mysql-4-1-nutshell
table-size full-table
year-2000-compliance y2k-issues