diff options
author | unknown <serg@serg.mysql.com> | 2001-12-16 21:27:54 +0100 |
---|---|---|
committer | unknown <serg@serg.mysql.com> | 2001-12-16 21:27:54 +0100 |
commit | f717676afbf3f1f187d9df11d02713ab82dd56b0 (patch) | |
tree | 3eac0fcfe6edc86bdfc52a2bc61a233ee586507d /Docs | |
parent | 565e5cc71de483e9bdf5ff6897c861190125db3e (diff) | |
download | mariadb-git-f717676afbf3f1f187d9df11d02713ab82dd56b0.tar.gz |
ALTER TABLE DISABLE/ENABLE KEYS section relocated
Diffstat (limited to 'Docs')
-rw-r--r-- | Docs/manual.texi | 18 |
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 |