summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorpaul@teton.kitebird.com <>2001-11-23 00:18:37 -0600
committerpaul@teton.kitebird.com <>2001-11-23 00:18:37 -0600
commitc1120d050d59f6a4e967236955318c8366480d95 (patch)
tree3599b375680579f24ace558fc5375947a59c38b9
parent0f5d7bcb11ef840424d55077882a02a70e33054f (diff)
downloadmariadb-git-c1120d050d59f6a4e967236955318c8366480d95.tar.gz
manual.texi miscellaneous minor cleanups
-rw-r--r--Docs/manual.texi66
1 files changed, 34 insertions, 32 deletions
diff --git a/Docs/manual.texi b/Docs/manual.texi
index d9e9d75876a..2a496cea958 100644
--- a/Docs/manual.texi
+++ b/Docs/manual.texi
@@ -3903,8 +3903,8 @@ This can be used to skip over extra columns in the text file,
or update columns based on expressions of the read data...
@item
@code{LOAD DATA INFILE 'file_name' INTO TABLE 'table_name' ERRORS TO err_table_name}
-This would cause any errors and warnings to be logged into the err_table_name
-table. That table would have a structure like:
+This would cause any errors and warnings to be logged into the
+@code{err_table_name} table. That table would have a structure like:
@example
line_number - line number in data file
@@ -3913,9 +3913,10 @@ and maybe
data_line - the line from the data file
@end example
@item
-Add true @code{VARCHAR} support (There is already support for this in MyISAM).
+Add true @code{VARCHAR} support (There is already support for this in
+@code{MyISAM}).
@item
-Automatic output from @code{mysql} to netscape.
+Automatic output from @code{mysql} to Netscape.
@item
@code{LOCK DATABASES}. (with various options)
@item
@@ -6954,18 +6955,19 @@ version 4.0;
@itemize @bullet
@item
@code{LOCATE()} and @code{INSTR()} are case sensitive if neither
-argument is a binary string. binary strings.
+argument is a binary string.
@item
-@code{INSERT INTO ... SELECT} had in 3.23 always @code{IGNORE} enabled.
-In 4.0.1 MySQL will stop (and possible rollback) in case of an error if you
+In 3.23,
+@code{INSERT INTO ... SELECT} always had @code{IGNORE} enabled.
+In 4.0.1, MySQL will stop (and possibly roll back) in case of an error if you
don't specify @code{IGNORE}.
@item
@file{safe_mysqld} is renamed to @file{mysqld_safe}.
@item
The old C API functions @code{mysql_drop_db}, @code{mysql_create_db} and
-@code{mysql_connect} are not supported anymore, unless one compiles
+@code{mysql_connect} are not supported anymore, unless you compile
MySQL with @code{CFLAGS=-DUSE_OLD_FUNCTIONS}. Instead of doing this,
-one should change the client to use the new 4.0 API.
+it is preferable to change the client to use the new 4.0 API.
@item
In the @code{MYSQL_FIELD} structure, @code{length} and @code{max_length} has
changed from @code{unsigned int} to @code{unsigned long}. This should not
@@ -6989,7 +6991,7 @@ Format of @code{SHOW OPEN TABLE} has changed.
Multithreaded clients should use @code{mysql_thread_init()} and
@code{mysql_thread_end()}. @xref{Threaded clients}.
@item
-If you want to recompile the perl DBD-MySQL module, you must get
+If you want to recompile the Perl DBD::mysql module, you must get
Msql-Mysql-modules version 1.2218 or newer, because the older DBD modules
used the deprecated @code{drop_db()} call.
@item
@@ -8346,7 +8348,7 @@ we may find some way to work around this problem.)
@item
@code{DROP TABLE} on a table that is in use by a @code{MERGE} table will
-not work on windows becasue @code{MERGE} handler does the table mapping
+not work on Windows because @code{MERGE} handler does the table mapping
hidden from the upper layer of MySQL. Because Windows doesn't allow you
to drop files that are open, you first must flush all @code{MERGE}
tables (with @code{FLUSH TABLES}) or drop the @code{MERGE} table before
@@ -8354,7 +8356,7 @@ dropping the table. We will fix this at the same time we introduce
@code{VIEW}s.
@item
@code{DATA DIRECTORY} and @code{INDEX DIRECTORY} directives in
-@code{CREATE TABLE} is ignored on windows, because windows doesn't support
+@code{CREATE TABLE} is ignored on Windows, because Windows doesn't support
symbolic links.
@end table
@@ -34692,20 +34694,20 @@ corrupt the table. This will be fixed in MySQL 4.0.x.
@item
Creation of a table of type @code{MERGE} doesn't check if the underlying
tables are of compatible types. If you use @code{MERGE} tables in this
-fasion you are very likely to run into strange problems.
+fashion, you are very likely to run into strange problems.
@item
If you use @code{ALTER TABLE} to first add an @code{UNIQUE} index to a
table used in a @code{MERGE} table and then use @code{ALTER TABLE} to
add a normal index on the @code{MERGE} table, the key order will be
-different for the tables if there was an old not-unique key in the
+different for the tables if there was an old non-unique key in the
table. This is because @code{ALTER TABLE} puts @code{UNIQUE} keys before
normal keys to be able to detect duplicate keys as early as possible.
@item
The range optimizer can't yet use @code{MERGE} table efficiently and may
-sometimes produce not optimal joins. This will be fixed in MySQL 4.0.x.
+sometimes produce non-optimal joins. This will be fixed in MySQL 4.0.x.
@item
@code{DROP TABLE} on a table that is in use by a @code{MERGE} table will
-not work on windows becasue @code{MERGE} handler does the table mapping
+not work on Windows because the @code{MERGE} handler does the table mapping
hidden from the upper layer of MySQL. Because Windows doesn't allow you
to drop files that are open, you first must flush all @code{MERGE}
tables (with @code{FLUSH TABLES}) or drop the @code{MERGE} table before
@@ -34718,12 +34720,12 @@ dropping the table. We will fix this at the same time we introduce
@cindex tables, ISAM
-You can also use the deprecated ISAM table type. This will disappear
+You can also use the deprecated @code{ISAM} table type. This will disappear
rather soon (probably in MySQL 4.1) because @code{MyISAM} is a better
-implementation of the same thing. ISAM uses a @code{B-tree} index. The
+implementation of the same thing. @code{ISAM} uses a @code{B-tree} index. The
index is stored in a file with the @code{.ISM} extension, and the data
is stored in a file with the @code{.ISD} extension. You can
-check/repair ISAM tables with the @code{isamchk} utility. @xref{Crash
+check/repair @code{ISAM} tables with the @code{isamchk} utility. @xref{Crash
recovery}.
@code{ISAM} has the following features/properties:
@@ -34741,7 +34743,7 @@ tables. @xref{MyISAM}. The major differences compared to @code{MyISAM}
tables are:
@itemize @bullet
-@item ISAM tables are not binary portable across OS/Platforms.
+@item @code{ISAM} tables are not binary portable across OS/Platforms.
@item Can't handle tables > 4G.
@item Only support prefix compression on strings.
@item Smaller key limits.
@@ -34757,7 +34759,7 @@ TABLE} statement:
mysql> ALTER TABLE tbl_name TYPE = MYISAM;
@end example
-The embedded MySQL versions doesn't support ISAM tables.
+The embedded MySQL versions doesn't support @code{ISAM} tables.
@node HEAP, InnoDB, ISAM, Table types
@section HEAP Tables
@@ -34768,7 +34770,7 @@ The embedded MySQL versions doesn't support ISAM tables.
makes them very fast, but if MySQL crashes you will lose all
data stored in them. @code{HEAP} is very useful for temporary tables!
-The MySQL internal HEAP tables use 100% dynamic hashing
+The MySQL internal @code{HEAP} tables use 100% dynamic hashing
without overflow areas. There is no extra space needed for free lists.
@code{HEAP} tables also don't have problems with delete + inserts, which
normally is common with hashed tables:
@@ -44797,7 +44799,7 @@ Some features:
@item Import wizard to import structure and data from MS Access, MS Excel, Dbase, FoxPro, Paradox, and ODBC Databases.
@item @uref{http://www.mysql.com/Downloads/Contrib/KMYENG113.zip}
-An administrator GUI for MySQL. Works only on windows, no source.
+An administrator GUI for MySQL. Works only on Windows, no source.
Available in English and Japanese. By Mitunobu Kaneko.
Home page: @uref{http://sql.jnts.ne.jp/}
@end itemize
@@ -45804,13 +45806,13 @@ Our TODO section contains what we plan to have in 4.0. @xref{TODO MySQL 4.0}.
@itemize @bullet
@item
@code{LOCATE()} and @code{INSTR()} are case sensitive if neither
-argument is a binary string. binary strings.
+argument is a binary string.
@item
-Fixed core dump bug in @code{UPDATE ... ORDER BY }.
+Fixed core dump bug in @code{UPDATE ... ORDER BY}.
@item
-Changed @code{INSERT INTO .. SELECT} to by default stop on errors.
+Changed @code{INSERT INTO .. SELECT} to stop on errors by default.
@item
-Ignore @code{DATA DIRECTORY} and @code{INDEX DIRECTORY} directives on windows.
+Ignore @code{DATA DIRECTORY} and @code{INDEX DIRECTORY} directives on Windows.
@item
Added boolean fulltext search code. It should be considered early alpha.
@item
@@ -45842,7 +45844,7 @@ be able to handle these.
Secure connections (with SSL).
@item
Unsigned @code{BIGINT} constants now work. @code{MIN()} and @code{MAX()}
-now handles signed and unsigned @code{BIGINT} numbers correctly.
+now handle signed and unsigned @code{BIGINT} numbers correctly.
@item
New character set @code{latin_de} which provides correct German sorting.
@item
@@ -45851,7 +45853,7 @@ functions. One bonus is that @code{DELETE FROM table_name} now returns
the number of deleted rows.
@item
@code{DROP DATABASE} now executes a @code{DROP TABLE} on all tables in
-the database, which fixes a problem with InnoDB tables.
+the database, which fixes a problem with @code{InnoDB} tables.
@item
Added support for @code{UNION}.
@item
@@ -46073,7 +46075,7 @@ Fixed problem with sjis character strings used within quoted table names.
Fixed coredump when using @code{CREATE ... FULLTEXT} keys with other table
handlers than MyISAM.
@item
-Don't use @code{signal()} on windows because this appears to not be
+Don't use @code{signal()} on Windows because this appears to not be
100 % reliable.
@item
Fixed bug when doing @code{WHERE column_name=NULL} on an indexed column
@@ -46224,7 +46226,7 @@ Don't force everything to lower cases on Windows. (To fix problem
with Windows and @code{ALTER TABLE}). Now @code{--lower_case_names}
also works on Unix.
@item
-Fixed that automatic rollback that is done when thread end doesn't lock
+Fixed that automatic rollback is done when thread end doesn't lock
other threads.
@end itemize
@@ -52168,7 +52170,7 @@ Pros for row locking:
@item
Fewer lock conflicts when accessing different rows in many threads.
@item
-Less changes for rollbacks.
+Fewer changes for rollbacks.
@item
Makes it possible to lock a single row a long time.
@end itemize