summaryrefslogtreecommitdiff
path: root/Docs
diff options
context:
space:
mode:
authorunknown <serg@serg.mysql.com>2001-12-16 21:27:54 +0100
committerunknown <serg@serg.mysql.com>2001-12-16 21:27:54 +0100
commitf717676afbf3f1f187d9df11d02713ab82dd56b0 (patch)
tree3eac0fcfe6edc86bdfc52a2bc61a233ee586507d /Docs
parent565e5cc71de483e9bdf5ff6897c861190125db3e (diff)
downloadmariadb-git-f717676afbf3f1f187d9df11d02713ab82dd56b0.tar.gz
ALTER TABLE DISABLE/ENABLE KEYS section relocated
Diffstat (limited to 'Docs')
-rw-r--r--Docs/manual.texi18
1 files changed, 9 insertions, 9 deletions
diff --git a/Docs/manual.texi b/Docs/manual.texi
index 4d059bd496a..1a9c9085b08 100644
--- a/Docs/manual.texi
+++ b/Docs/manual.texi
@@ -34542,15 +34542,6 @@ options, MySQL simply renames the files that correspond to the table
@xref{RENAME TABLE,, @code{RENAME TABLE}}.
@item
-Since @strong{MySQL 4.0} the above feature can be activated explicitly.
-@code{ALTER TABLE ... DISABLE KEYS} makes MySQL to stop updating
-non-unique indexes for @code{MyISAM} table.
-@code{ALTER TABLE ... ENABLE KEYS} then should be used to recreate missing
-indexes. As MySQL does it with special algorithm which is much
-faster then inserting keys one by one, disabling keys could give a
-considerable speedup on bulk inserts.
-
-@item
@code{create_definition} clauses use the same syntax for @code{ADD} and
@code{CHANGE} as for @code{CREATE TABLE}. Note that this syntax includes
the column name, not just the column type.
@@ -34650,6 +34641,15 @@ indexes are created in a separate batch (like in @code{REPAIR}).
This should make @code{ALTER TABLE} much faster when you have many indexes.
@item
+Since @strong{MySQL 4.0} the above feature can be activated explicitly.
+@code{ALTER TABLE ... DISABLE KEYS} makes MySQL to stop updating
+non-unique indexes for @code{MyISAM} table.
+@code{ALTER TABLE ... ENABLE KEYS} then should be used to recreate missing
+indexes. As MySQL does it with special algorithm which is much
+faster then inserting keys one by one, disabling keys could give a
+considerable speedup on bulk inserts.
+
+@item
@findex mysql_info()
With the C API function @code{mysql_info()}, you can find out how many
records were copied, and (when @code{IGNORE} is used) how many records were